Explain the definition of normalized and denormalized view and what are the diff

Explain the definition of normalized and denormalized view and what are the differences between them?

Question Posted / murali

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

More Data Warehouse General Interview Questions

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

How to pivot data using informatica when you have variable amount of pivot rows?

What needs to be done when the database is shutdown?

How many types of facts and what are they?

Code the tables statement for a single-level (most common) frequency?

What is scd1 , scd2 , scd3?

What is a core dimension?

explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I

What are the various transformation available?

What is the difference between a W/H and an OLTP application?

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

What is an OLAP (On-line Analytical processing) system?

For more Data Warehouse General Interview Questions Click Here