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
explain abt ur project architecture?
What does update strategy mean, and what are the different option of it?
What is meant by LDAP users?
tell me the rules and responsblites in our project(my project is development)
What are data-driven sessions?
Different qualification between a related rotate toward the sky and isolates look upward?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the use of source qualifier?
What is the sql query overwrite in source qualifier in informatica
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How can repository reports be accessed without sql or other transformations?
waht type of interface is used for testing the data in informatica
Explain the use of aggregator cache file?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the new features of informatica 9.x at the developer level?