Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages of de normalized data?
- 2 Answers
- 11342 Views
- I also Faced
- E-Mail Answers
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 can report net connect multiple datasource at a time in report creation time?
What are the different types of fact tables used in data warehousing?
How do you define data block size?
What is meant by metadata in context of a data warehouse and how it is important?
What is the difference between dependent data warehouse and independent data warehouse?
What is a star schema? Why does one design this way?
Explain what is the difference between olap and datawarehosue?
What are vaious etl tools in the market?
What a static and local variable?
What's a Cube in Rolap?
if you use oracle sql*loader , how do you transform data with it during loading?
Explain what is a cube in data warehousing concept?
Teradata 
