Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to structure query/tables?

Hi,   At the moment, my queries are structured like this: Answers, Companies, Filters. Problem is, "Answers" contains Facts (Answers) as well as Filters (Segments, SubSegments, F1, For Companies o...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Should I create two fact-tables?


Answers (fact1) and Filters belonging to them (dim1)
Companies (fact2) and Filters belonging to them (dim2)