Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Advantages of de normalized data?
- 3 Answers
- 9051 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mahesh
Denormalized data makes data retrieval operation faster and
reliable due to minimum number of joins used for
it.Therefore it improves the performance of the system.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / eric yang
De-normalized data can save more space and have better
performance when run a sql for it
| Is This Answer Correct ? | 0 Yes | 21 No |
How to do unit testing in informatica?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
what is fact and what types of fact tables is there
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
what are the perameter and variable?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
How can we get multiple output values using an unconnected lookup transformation?
permutations of mapplet
HOW TO GET THE LATEST DATA IN SCD ?
how to work with mapplet designer in informatica?
difference between stop and abort
Teradata 
