Sample Header Ad - 728x90

Star Schema from Relational Database

4 votes
2 answers
3563 views
I'm a newbie to data warehousing and I've been reading articles and watching videos on the principles but I'm a bit confused as to how I would take the design below and convert it into a star schema. In all the examples I've seen the fact table references the dim tables, so I'm assuming the questionId and responseId would be part of the fact table? Any advice would be much appreciated. enter image description here
Asked by saj (93 rep)
Jul 25, 2016, 01:49 PM
Last activity: Nov 27, 2023, 11:05 PM