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
Which files are created during the session rums by informatics server?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
tell me the rules and responsblites in our project(my project is development)
What do you mean by worklet?
What are data-driven sessions?
What is joiner transformation in informatica?
How many number of sessions can one group in batches?
How many ways a relational source definition can be updated and what are they?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How can a transformation be made reusable?
What is a snowflake schema?
How to join three sources using joiner? Explain though mapping flow.
Quickly characterize reusable change?
What does role playing dimension mean?
What is complex mapping?