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 generate sequence numbers without using the sequence generator transformation?
What is xml source qualifier transformation in informatica?
What is rank transform?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is deployment group?
What does reusable transformation mean?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain the difference between mapping parameter and mapping variable?
How to use pmcmd utility command?
What do think which one is the better joiner or look up?
What are the measure objects?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
While migrating the data from one environment to another environment how would you manage the connections?