Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 9408 Views
- Informatica, I also Faced
- E-Mail Answers
Answer Posted / nitin
1) Src-->SQ->Normalizer-->Target
The first pipeline breaks the rows and convert to columns and then write to target file.
1|A
1|B
1|C
1|D
2|A
2|B
3|A
3|B
2)Src->SQ->Exp->Target
The second pipeline receives the above output with '|' as delimiter and passes to expression.
In the expression transformation concatenate the second column with + for the same first column and then write to target with | as delimiter
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the popular informatica products?
State the differences between sql override and lookup override?
what is the -ve test case in your project.
Why filter transformation is an active one?
What is lookup transformation?
How do you change a non-reusable transformation to reusable transformation?
what is the complex transformation you used in informatica
How do you set a varible in incremental aggregation
How many transformations can be used in mapplets.
Differences between version 7.x and 8.x.
what is Active lock explain
How to use pmcmd utility command?
What is a filter transformation and why it is an active one?
How to generate sequence numbers using expression transformation?
Is stop and abort are same in informatica?
