Differentiation between star and snowflake schemas
Briefly describe the differentiation between star and snowflake schemas?
Expert
Star schema : A highly de-normalized method. A star schema has one fact table and is related with frequent dimensions table and depicts a star.
Snow flake schema : The normalized principles applied star schema is named as Snow flake schema. Each and Every dimension table is related with sub dimension table. Differences :
A dimension table will not have parent table in star schema, while snow flake schemas have one or further parent tables.
The dimensional table itself comprises of hierarchies of dimensions in star schema, while hierarchies are divide in various tables in snow flake schema. The drilling down data from top mainly hierarchies to the lowermost hierarchies can be done.
Write a brief note on the market basket analysis?
Explain about extension and intension.
State the types of users in the Business Objects?
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Explain how in a relation a supertype or subtype is mapped?
Determine the stand-alone procedures?
Illustrate briefly the term DBMS?
Explain the difference between expression and aggregator?
When two relational tables is connected to SQ Trans, what are the probable errors it will be thrown?
Give a brief introduction of the term XMLA?
18,76,764
1950100 Asked
3,689
Active Tutors
1446337
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!