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
- 8993 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
Define Pmrep command?
How to elaborate tracing level?
How do you use reject loader.
How can you define user defied event?
What is the benefit of partitioning a session?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is primary and backup node?
can u any challenge your project?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the issues you have faced in your project? How did you overcome those issues?
What are the limitations of joiner transformation?
What is the scenario which compels informatica server to reject files?
Which are the different editions of informatica powercenter that are available?
What differs when we choose the sorted input for aggregator transformation?
What are mapplets? How is it different from a Reusable Transformation?
