Explain why dimenstion tables are denormalized in nature?

Question Posted / kapil agari

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

More Data Warehouse General Interview Questions

Why joiner transformation does not allow the aggregator transformation and expression transformation to join

What are snapshots? What are materialized views & where do we use them?

where exactly in dataware house a confirmed dimension can be created

How to provide security in frame work manager for a query subject?

Whether dimension table can have numeric value?

Explain difference between data ware house & data mart?

what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

Explain when do we analyze the tables? How do we do it?

What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

Explain what are fact, dimension, and measure?

What are the key columns in Fact and dimension tables?

Explain differences between star and snowflake schemas?

For more Data Warehouse General Interview Questions Click Here