i'm working towards star schema database includes details both results individuals have undergone training , assessment, , feedback on training. maintain simplicity , performance makes sense limit number of fact tables, planning on using 1 fact table, , separate feedback , score data using dimension.
the issue of feedback data in string format (written answers) opposed numerical format. how should approach reconciling 2 types of data 1 fact table, or should have 2 fact tables, 1 string based feedback answers , 1 numerical scores. or make more sense in fact have 3 fact tables, 1 scores, 1 feedback numerical data, , 1 feedback data in string format?
the main driver of modelling of schema expected queries.
if have imagination how queries formulated, simple check 3 options , compare results.
if can't anticipate queries, probable best way start scheme 1:1 inputs , react if necessary.
Comments
Post a Comment