Answer Posted / 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 |
Post New Answer View All Answers
How to differentiate between the active and passive transformations?
Briefly define reusable transformation?
Explain lookup transformation in informatica
How can we remove the duplicates from flat file source?
Describe expression transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Make a note of the quantity vaults made in informatica?
What is the reusable transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is the advantage of informatica?
Is there any target staging area in informatica not staging area
What are the settings that you use to configure the joiner transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the different transaction levels available in transaction control transformation?
How to update a particular record in target with out running whole workflow?