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
Explain the aggregator transformation?
What are batches?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain target update override in informatica
explain abt ur project architecture?
Write the unconnected lookup syntax?
What is the difference between STOP and ABORT options in Workflow Monitor?
What are the types of caches in lookup? Explain them.
Mention a few design and development best practices for informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain the mapping variable usage example in informatica
wf dont have integration severances how you can run?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Why is sorter an active transformation?
How many ways are there to create ports?
