Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / samir kumar sahoo
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 |
Post New Answer View All Answers
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain difference between snow flake and star schema.
What are the different types of fact tables used in data warehousing?
How to generate iqd file from framework manager?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Suggest a good author for hyperion in data warehousing?
What is aggregate fact table?
Explain ddl (data definition language)?
What is a staging area? Do we need it? What is the purpose of a staging area?
What are session timeout and application timeout?
What is the purpose of Dataware Control?
What are the approaches used by optimizer during execution plan?
What is metadata in context of a datawarehouse and how it is important?
