Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Advantages of de normalized data?
- 3 Answers
- 8753 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 |
Where can we find the throughput option in informatica?
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
What is DTM process?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
why u go for dimensions ?
Name the different lookup cache(s)?
what is filelist concept in informatica
How to call stored Procedure from Workflow monitor in Informatica 7.1 version?
Why is sorter an active transformation?
What is intricate mapping?
Teradata 
