What are the Advantages of de normalized data?
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 |
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
What is deployemnt groups, Lables, query and dynamic deployment group.
what is the size of your data warehousing?
What is the difference between SOURCE and TARGET BASED COMMITS?
What is primary and backup node?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
Enlist few areas or real-time situations where informatica is required.
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
What is an expression transformation?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
How do you change a non-reusable transformation to reusable transformation?
what is junk dimension