Forum Discussion
jct999
Advocate II
Advocate IIBest data modeling approach with hierachical source data
Hello, I receive 4 tables : 3 tables form a hierarchical structure, and the last one one is a fact table. The relations between these 4 table is like this : LEVEL_1 --(one to many)--> LEVE...
jct999 , Based on what I got. In case Level 1 , level 2 and level 3 are need both as fact and dimension. fact means they have something to aggregate
Like fact will be modified to have keys from level 2 and level 2. Level 2 will created as fact and Level 2 dim. Level 2 fact will have key and data from level 1
same way you can have level 3 fact
amitchandak
Super User
Super Userjct999 , Based on what I got. In case Level 1 , level 2 and level 3 are need both as fact and dimension. fact means they have something to aggregate
Like fact will be modified to have keys from level 2 and level 2. Level 2 will created as fact and Level 2 dim. Level 2 fact will have key and data from level 1
same way you can have level 3 fact