When Should You Consider Denormalization?

1.	When Should You Consider Denormalization?
Answer» DENORMALIZATION is used when there are a lot of TABLES involved in retrieving data. Denormalization is DONE in DIMENSIONAL modelling used to construct a data ware house. This is not usually done for data bases of TRANSACTIONAL systems. Denormalization is used when there are a lot of tables involved in retrieving data. Denormalization is done in dimensional modelling used to construct a data ware house. This is not usually done for data bases of transactional systems.

Answer»

DENORMALIZATION is used when there are a lot of TABLES involved in retrieving data. Denormalization is DONE in DIMENSIONAL modelling used to construct a data ware house. This is not usually done for data bases of TRANSACTIONAL systems.

Denormalization is used when there are a lot of tables involved in retrieving data. Denormalization is done in dimensional modelling used to construct a data ware house. This is not usually done for data bases of transactional systems.

Discussion

No Comment Found

Related InterviewSolutions

What Is Second Normal Form?
What Is An Artificial (derived) Primary Key? When Should It Be Used?
Is This Statement True Or False? All Databases Must Be In Third Normal Form?
Why Are Recursive Relationships Are Bad? How Do You Resolve Them?
What Is Third Normal Form?
What Is Erd?
When Should You Consider Denormalization?
What Is The Difference Between Hashed File Stage And Sequential File Stage In Relates To Datastage Server?
What Is Data Sparsity And How It Effect On Aggregation?
What Is The Difference Between Star Flake And Snow Flake Schema?

When Should You Consider Denormalization?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment