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 connected and unconnected stored procedures?
What are the differences between datamart vs. Reporting cube?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is batch processing?
Explain what is power center repository?
Can any one explain the hierarchies level data warehousing.
What is operational data store (ods)?
Explain what is cost benefit analysis (cba)?
Explain the structure of cold fusion?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Explain the data type of the surrogate key?
What are the different types of schemas used in data warehousing?
Explain where do we use semi and non additive facts?