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.
Explain the term Account and Directory options?
Illustrates the term Monopolistic Competition?
Explain the term intelligent binning?
Explain the term replication server software?
Explain the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
Specify the various types of Aggregation?
Describe the differences between unstructured data and structured data?
Give details why an information gap exists in most organizations?
Illustrates storing of data in stored procedures increase the access time?
Explain what is meant by the term stored procedures?
18,76,764
1935010 Asked
3,689
Active Tutors
1449962
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!