Explain difference between e-r modeling and dimentional modeling?

Question Posted / murali

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

More Data Warehouse General Interview Questions

Explain what are the different methods of loading dimension tables?

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

What is execution plan?

Explain why fact table is in normal 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?

Where we use surrogate key explain with example?

What is a fact table?

Explain how many ways you create ports?

What is the difference between a primary and secondary actor in use case modeling?

Explain grouped cross tab?

Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?

Why we use repository connectivity?

For more Data Warehouse General Interview Questions Click Here