I HAVE A SOURCE FILE CONTAINING
1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B
AND IN TARGET I SHOULD GET LIKE
1|A+B+C+D
2|A+B
3|A+B
WHICH TRANSFORMATION I SHOULD USE
Answer Posted / ankit kansal
There is only one row as per the defined problem. so first you have to break down this one row into multiple rows as separated by delimiter ','.
1|A
1|B
1|C
1|D
2|A...
Now in Expression Transformation using some string functions and later using rank/aggregator T/S you can achieve your result...
http://deepinopensource.blogspot.in
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the code page compatibility?
What is the difference between a connected look up and unconnected lookup?
Do you find any difficulty while working with flat files as source and target?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
can you please explain me pre session and post session options?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
list out all the transformations which use cache?
What is flashback table ? Advance thanks
Explain about cumulative Sum or moving sum?
What is the difference between informatica 7.0 and 8.0?
What is source qualifier transformation in informatica?
Slowly changing dimensions, types and where will you use them
Explain the tuning lookup transformation - informatica
What are the types of presistent cache in look up tr.
What is informatica etl tool?