⟩ What is the Differences between star and snowflake schemas?
Star schema - all dimensions will be linked directly with a fat table.
Snow schema - dimensions maybe interlinked or may have one-to-many relationship with other tables.
Question and Answer:
Home General Datawarehousing
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
How to stop a batch?
What is EDW?
If two relational tables are connected to SQ Trans, what are the possible errors it will be thrown?
What is the Difference between static cache and dynamic cache?
What are Target Types on the Server?
What are the reusable transforamtions?
Explain How many ways you create ports?
Suppose if a session fails after loading of 10,000 records in to the target.How can you load the records from 10001 the record when you run the session next time?
What are Aggregate transformation?
What is the difference between Power Center and Power Mart? What is the procedure for creating Independent Data Marts from Informatica 7.1?
