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 |
what is the difference between aggregate table and fact table ? how do you load these two tables ?
What are the various file formats involved in reportnet?
What is data mart in data warehouse?
Why null values are mapped as 0 in fact tables?
What is META DATA information in Data warehousing projects?
wat is code review and wat actually srs or how can we create HLD,LLD.PLS,GIVE ME ANSWER AS EARLY AS FAST.
Explain what is ods (operation data source)?
What is the difference between connected and unconnected stored procedures?
how to find unique records in informatica level
what is the difference between etl tool and olap tools
What are the differences between star and snowflake schema?
What is the "junk dimension"? Give with examples?