Wide and large Dimension or Survey Factless Fact Table
Page 1 of 1
Wide and large Dimension or Survey Factless Fact Table
Hi
I would like some advice on this particular point. We receive responses to surveys containing hundreds of questions. Those surveys are submitted many times to about ten thousands people we follow. Their answers could change in time. Usually the questions aren't associated to numerical value.
What's more, new questions are asked and some aren't asked anymore.
To represent such datas, i could have a wide and quite huge SCD type 2 dimension or a huge factless fact table like described on page 197 in The Datawarehouse Toolkit.
Users want to cross answers to a particular question with answers to others and then identify precisely peoples corresponding.
They also want to filter data from other fact tables with specific answers.
I think the 2 solutions could be used but the SCD seems to me very hard to maintain and the factless very hard to query.
A composite solution could be to duplicate most used questions as an attribute in the dimension and a fact in survey data. Does such a solution sound acceptable ? have you an idea of the performance problems I could encounter.
Thx for your ideas
Guillaume
I would like some advice on this particular point. We receive responses to surveys containing hundreds of questions. Those surveys are submitted many times to about ten thousands people we follow. Their answers could change in time. Usually the questions aren't associated to numerical value.
What's more, new questions are asked and some aren't asked anymore.
To represent such datas, i could have a wide and quite huge SCD type 2 dimension or a huge factless fact table like described on page 197 in The Datawarehouse Toolkit.
Users want to cross answers to a particular question with answers to others and then identify precisely peoples corresponding.
They also want to filter data from other fact tables with specific answers.
I think the 2 solutions could be used but the SCD seems to me very hard to maintain and the factless very hard to query.
A composite solution could be to duplicate most used questions as an attribute in the dimension and a fact in survey data. Does such a solution sound acceptable ? have you an idea of the performance problems I could encounter.
Thx for your ideas
Guillaume
scoob- Posts : 3
Join date : 2011-03-23
Age : 46
Location : France
Similar topics
» very large/wide fact table considerations?
» Large Dimension table compared to fact table?
» SCD Type 2 on large and wide dimension tables
» Factless fact table versus Dimension (downstream implications)
» Factless Fact table or 1:M Dimension Relation
» Large Dimension table compared to fact table?
» SCD Type 2 on large and wide dimension tables
» Factless fact table versus Dimension (downstream implications)
» Factless Fact table or 1:M Dimension Relation
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum