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 / mithilesh kumar rai
First Use Expression and then Use Aggregater
After Expression U will receive
1 a
1 a b
1 a b c
2 a
2 a b
2 a b c
then use aggregater group by key 'ID'
After Aggregater u will receive
1 abc
2 abc
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Difference between Data and Index Caches?
What is sorter transformation?
How does a rank transform differ from aggregator transform functions max and min?
list out all the transformations which use cache?
Explain informatica architecture - version 8 / 9
What is a joiner transformation?
Did u used latest transformations of 8.6.0? for what?
What is rank transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What is meant by incremental aggregation?
Under what condition selecting sorted input in aggregator may fail the session?
What is the need of etl tools?
What is meant by lookup transformation?
How to update or delete the rows in a target, which do not have key fields?
Explain lookup transformation in informatica