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.
Name four applications which are employing for triggers in DBMS?
Why recursive relationships are not good? How do you solve them?
How can we increase the performance within the Data Stage?
Write down the differentiation between Power Center and Power Mart?
Define the term DataStage?
Write down a short note on XML and also describe the uses of it?
Reduction in Cost: Huge reduction in costs can be achieved due to cloud computing both in terms of capital expenditure and operational expenditure. Since the organization now need not build its own
State the components of report studio?
What do you mean by the term Open Server in the Sybase?
Explain the way to unzip a File in SSIS.
18,76,764
1926359 Asked
3,689
Active Tutors
1425883
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!