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.
Categorize the Hashing Functions based on the different methods through which the key value is found?
Give a brief differentiation between metadata and data dictionary?
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
Explain the difference between ARRAY and STACK in Data Structures?
State the use of data stage jobs?
Write a short note on the differences between vertical and horizontal portioning?
Described the impact of signed numbers upon the memory by using Data Structures?
Briefly describe EDW?
Explain what is meant by the repository and what does it consists of?
List out the main attributes of the data stage?
18,76,764
1947796 Asked
3,689
Active Tutors
1446828
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!