Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kris
De Normalised Data:
A table storing denormalised data occupies more space
because lot of duplicate information creeps in when we
denormalise a table.
As less number of join conditions are required to retrieve
data from one/more denormalised tables, the performance
will be fast.
DWH environment prefers denormalised data structures.
| Is This Answer Correct ? | 27 Yes | 2 No |
Post New Answer View All Answers
What are the main features of Oracle 8i with context to datawarehouse?
What is the cumulative sum and moving sum?
Why sorter is an active transformation?
Write the prerequisite tasks to achieve the session partition?
How many number of sessions can one group in batches?
Is there any target staging area in informatica not staging area
If informatica has its scheduler why using third party scheduler?
What is a grid in Informatica?
What are data-driven sessions?
How can you validate all mappings in the repository simultaneously?
In warehouses how many schemas are there?
How will the document be delivered to me?
What is dimensional table?
What are the designer tools for creating transformations?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
