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
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the types of data warehouses?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the function of look up transformation?
Enlist the differences between database and data warehouse.
What are junk dimensions?
Is it possible to create multiple domains on a single Informatica server?
What is a code page?
What is main use of mapplet?
COM components can be used in Informatica
What do you mean by channel change?
what is the difference between informatica6.1 and infomatica7.1
How can we remove the duplicates from flat file source?
Differences between connected and unconnected lookup?
How can we use mapping variables in informatica? Where do we use them?