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
Explain what are components of reportnet?
How do you define data block size?
Why should you put your data warehouse on a different system than your oltp system?
Explain a relation schema and a relation?
what is an use case?
Explain what are necessary tasks to install reportnet software?
What is data stream and data adaopter?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is a relationship?
what are the others of "bad files" and "discard files" when using sql*loader?
what are the all possible features supported modify stage?
Explain what is the data type of the surrogate key?
What is degenerate dimension table?
What is crass reference table?
Explain what is the difference between stop and abort?