⟩ What are the differences between star and snowflake schema?
Star schema: A single fact table with N number of DimensionSnowflake schema: Any dimensions with extended dimensions are known as snowflake schema.
Question and Answer:
Home Data Warehousing
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Suppose we have some 10,000 odd records in source system and when load them into target.How do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain What are the different versions of Informatica?
How can we determine what records to extract?
Explain What is a three tier data warehouse?
Explain Where do we use semi and non additive facts?
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
Explain What is the difference between Power Center & Power Mart?
Explain What are the various transformation available?
Tell me what is Full load & Incremental or Refresh load?
Explain Techniques of Error Handling - Ignore , Rejecting bad records to a flat file , loading the records and reviewing them (default values)?
