Data Modeling Question:
Download Questions PDF

When should you consider denormalization?

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?