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 er modeling and dimensional modeling?
What are the data types present in bo?
What are the stages that are required in data warehousing?
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 static cache and dynamic cache?
Explain differences between star and snowflake schemas?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
what are relationships?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
explain about dirty dimension?
What is Sequence clustering algorithm?
Where do we use semi and non additive facts?
What are the steps involved in designing a fact table?
What is Active Datawarehousing?
Explain what are the basic needs to join two sources in a source qualifier?