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 tkprof and how is this used?
What is meant by the fact table?
Explain briefly the term Web Services?
Explain the term lattice of cuboids in brief.
Write down the snapshot with reference to data warehouse?
Improvement in Automation: Cloud computing is designed and coded to perform a lot of operations by itself. It has been designed to operate in a completely automated fashion. It enhances the efficiency of the organization.
What is the archtetype or instance pattern?
What are the purposes of using lookups?
Explain the term Super servers?
Explain the Aggregate Awareness?
18,76,764
1939001 Asked
3,689
Active Tutors
1428435
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!