If the source has duplicate records as id and name columns,
values:
1 a, 1 b, 1 c,
2 a, 2 b,
the target should be loaded as 1 a+b+c or 1 a||b||c, what
transformations should be used for this?
Answer Posted / souvik
We need to have a Lookup with a Dynamic Cache, a Router, an Expression and then an Update Strategy..... The Lookup will be on the Target Table..... So when the ID is coming for the first time, it wont found any data on the lookup table.... This can be directed for Insertion to the Target Table via a Router.... Then when the same ID is coming for the second time, it will Lookup on the Target Table and will found that the row with the ID exists.... Hence both the columns from the source table and both the columns from the Lookup are taken forward into the Router and then to an Expression Transformation where the second port is Concatenated. Then the ID port and this port is taken to the Update Strategy transformation for Update...
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
what is the -ve test case in your project.
What are the features of complex mapping?
can anyone suggest best free Talend data integration training online
What do you mean by channel change?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain sessions?
Explain lookup transformation in informatica
What is option by which we can run all the sessions in a batch simultaneously?
What the difference is between a database, a data warehouse and a data mart?
What are Dimensional table?
Have you worked with/created Parameter file
Name the different lookup cache(s)?
How do you take back up of repository?
What is the difference between Active and Passive transformation?