Explain differences between star and snowflake schemas?

Question Posted / murali

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

More Data Warehouse General Interview Questions

State any 5 of Cods guidelines of an OLAP system, brief description each?

What is meta data and system catalog?

How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?

Fact table is in normalized or de-normalized form?

What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

Explain what is the metadata extension?

Where the applications and where ware house management system is used?

I need a good brd and uc template?

What is the advantages data mining over traditional approaches?

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

How can you define a transformation? What are different types of transformations in Informatica?

what is the difference between aggregate table and fact table ? how do you load these two tables ?

For more Data Warehouse General Interview Questions Click Here