"A dimension table is wide but the fact table is deep," explain the st

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

Question Posted / tajuddin

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

More Data Warehouse General Interview Questions

What are the types of dimensional modeling?

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

What are the different types of data warehouses?

Explain why fact table is in normal form?

What is an OLTP (Online Transaction Processing) System?

I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE

What are the primary ways to store data in OLAP?

Explain which columns go to the fact table and which columns go the dimension table?

What are the different methods of loading dimension tables?

What is load manager?

What is incremintal loading?

Explain what are data marts?

For more Data Warehouse General Interview Questions Click Here