Advantages of de normalized data?
Answers were Sorted based on User's Feedback
Answer / 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 |
Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.
Is This Answer Correct ? | 10 Yes | 5 No |
Explain what are the mapping paramaters and maping variables?
where exactly in dataware house a confirmed dimension can be created
Can you brief about the Data warehouse project you worked on?
What is power play plug in?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What is the difference between a data warehouse and a data mart?
15 Answers Apex, ASD Lab, Bank Of America,
What are Aggregate tables?
What is dimension modeling?
Store (and count) non-fact records?
Difference between ODS and Staging
What are the differences between star and snowflake schema?
what role views play in dimensional modeling?