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.
Sustainability: Cloud computing consumes very less energy and resources than a sophisticated IT infrastructure. It helps in better sustainability of the organization.
Briefly describe the differentiation between data warehousing and data mining ?
Explain the term optimization and performance tuning and its work in practical projects?
Explain the types of jobs we have within the Data stage?
Determine the stand-alone procedures?
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
Write about the components of the Ascential Data Stage?
Elucidate briefly what is the mapping variables and mapping parameters?
Stats the term ERD?
How you can detect the loops?
18,76,764
1940247 Asked
3,689
Active Tutors
1459436
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!