1.

What is extended Star schema? Which of the tables are inside and outside cube in an extended star schema?

Answer»

In Extended Star schema, Fact tables are connected to Dimension tables and dimension table is connected to SID table and SID table is connected to master data tables. In Extended star schema you have Fact and Dimension tables are inside the cube however SID tables are outside cube. When you load the transactional data into Info cube, Dim Id’s are generated based on SID’s and these Dim id’s are used in fact tables.


Discussion

No Comment Found

Related InterviewSolutions