Explain difference between snow flake and star schema.

Question Posted / murali

No Answer is Posted For this Question
Be the First to Post Answer

More Data Warehouse General Interview Questions

if we increase the number of dimensions will the rows in fact table increase or decrease??

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

Where we use surrogate key explain with example?

what is a hot file, why we need in datawarehousing, where we used in general

How to stop a batch?

What are the different ways to represent the loading of dimension tables?

What is metadata in context of a datawarehouse?

What is Sequence clustering algorithm?

What is the use of dimensional modeling in data warehousing?

What is surrogate key? Explain with examples.

Explain a mapping, session, worklet, workflow, mapplet?

How are the dimension tables designed?

For more Data Warehouse General Interview Questions Click Here