How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
Answer Posted / ani
We cannot use normalizer transformation in this case.
It used for normalizing the records.
Use decode in expression transformation and then aggregator
transformation.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Please let me know how to make encryption and decryption with example?
What is the need for an etl tool?
Difference between Data and Index Caches?
What is the difference between a connected look up and unconnected lookup?
What are the various types of transformation?
How can we delete duplicate rows from flat files?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How can you generate reports in informatica?
How to update or delete the rows in a target, which do not have key fields?
Explain what is informatica metadata and where is it stored?
What is sequence generator transformation in informatica?
Define the various join types of joiner transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is pmcmd command?
How to join three sources using joiner?