Data Modeling Question:

Download Job Interview Questions and Answers PDF

When should you consider denormalization?

Data Modeling Interview Question
Data Modeling Interview Question

Answer:

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

Download Data Modeling Interview Questions And Answers PDF

Previous QuestionNext Question
What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?What is ERD?