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
pmscmd startworkflow -sv
How to differentiate between the active and passive transformations?
Is it possible to define a single node as a Gateway node as well as worker node?
How can a transformation be made reusable?
draw informatica architecture 8.6 ?
How to implement security measures using repository manager?
What is a transaction control transformation?
How to generate sequence numbers without using the sequence generator transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is DR strategy for Informatica project?
Can u generate reports in Informatica?
Define Pmrep command?
What are mapplets? How is it different from a Reusable Transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How do you load alternate records into different tables through mapping flow?