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.
How can I partition any table in Sybase? Explain.
Illustrates the introduction about economics?
Write down the latest error handling technique in SQL Server 2005?
Define the term DataStage?
What are sequences, and what are the possible problems when employing them to make surrogate keys?
Write down the security level employed in BO?
States the term Volatile temporary tables.
Illustrates the two tasks to be assigned to similar partition in Sybase?
Illustrates all databases should be in third normal form or not?
Write down brief note on the issues for database performance?
18,76,764
1951026 Asked
3,689
Active Tutors
1460811
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!