Answer Posted / bharat kalra
De-normalization is a concept used for fast data retrieval
as it reduces the number of joins to be performed in the
select query.
It's reverse of normalisation as any normalised data base
is optimized for DML operations(insert,update,delete).
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
What is the difference between er modeling and dimensional modeling?
What is a fact, dimension, measure?
Fact table is in normalized or de-normalized form?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Is there any rownum object from which we can do this?
How can we run the graph? How can we schedule the graph in unix?
Where the applications and where ware house management system is used?
What is Cognos script editor?
What is vldb(very large databases)?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What is factless fact tables?
What are the various file formats involved in reportnet?
Explain what are components of report studio?
What is the difference between olap and oltp?
