Star Schema design -
i have question in regards star schema design, whether need use snowflake (which read should avoided). have following 3 dimension tables:
- main list dim. - contains list of people
- sub lists dim. - contains sorts of combinations main list
- program dim. - identify lists of programs, each program connected sub list
each row in fact table contain keys following 3 tables (and metrics), issue - sub lists can exact list (in terms of list content) pointing different programs. should create in sub list dimension repetition of same content or should use snow flake connect between sub lists , programs? example - assuming main list contain 100k records, , have 3 programs a, b , c. program has 10k sub list have 10k entries in sub list dimension, program b , c have same sub list 30k records, should create 60k entries, 30k per each?? important note there other attributes in program dim differentiate between each program, , fact data @ program level.
thanks!
Comments
Post a Comment