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 are batches?
Explain the different dimensions.
Why filter transformation is an active one?
Define joiner transformation?
What you know about transaction control transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How you prepared reports for OLAP?
Informatica settings are available in which file?
What is domain and gateway node?
How do you load only null records into target?
What is Index Caches size?
Explain lookup transformation in informatica
What do you understand by a term domain?
Explain the tuning lookup transformation - informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?