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.
Illustrates the term update statistics in Sybase?
Illustrate the multi value or multicolumn problem? Include an example not employed in the text.
Explain the way to swap a db device along with other.
Write down the brief note on the differentiations between Normalizer and Normalizer transformation?
Describe the difference between complexType elements and simple elements?
Why there is a need to create the user object?
Give brief introduction of the term broad cast agent?
Describe a surrogate key and also explain the ideal primary key and illustrate how surrogate keys meet up this ideal?
Write down brief note on the issues for database performance?
Write down the purpose of Fact-less Fact Table?
18,76,764
1938192 Asked
3,689
Active Tutors
1412485
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!