If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?
Answer Posted / saritha
you can use normalizer or expersion transformation.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is the benefit of partitioning a session?
What is the maplet?
Difference between Target-based loading and constraint-based loading?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is the scenario which compels informatica server to reject files?
What are the different versions of informatica?
How can informatica be used for an organization?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How might one distinguish in the case of mapping is right or not without associating session?
What are the differences between source qualifier and joiner transformation?
According to his methodology what all you need before you build a datawarehouse
What is rank transformation?
what is size of u r database?
What is the need of an ETL tool?
Explain lookup transformation source types in informatica