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

What is Sequence clustering algorithm?

What we will do with the universe for faster process?

Compare and contrast aggregates & indexes

Explain what are components of reportnet?

What is the definition of cube in datawarehousing?

Give me a broad concept of what a data warehouse is, and what it might be used for?

When should one use an MD-database (multi-dimensional database) and not a relational one?

What is your spectra photometer working principles?

Suppose we want to display zero when null values coming to report how can we do that?

How can we load the time dimension?

What is a staging area? Do we need it? What is the purpose of a staging area?

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

For more Data Warehouse General Interview Questions Click Here