Data Modeling Question: Download Data Modeling 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.
| Previous Question | Next Question |
| What is the difference between hashed file stage and sequential file stage in relates to DataStage Server? | What is ERD? |