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
- 9213 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 is parallel processing in informatica?
How to open an older version of an object in the workspace?
What is the difference between a connected look up and unconnected lookup?
Partition, what happens if the specified key range is shorter and longer
What is fact table? Explain the different kinds of facts.
Define Pmrep command?
Explain the types of transformations?
Explain how to import oracle sequence into informatica?
Explain the types of lookup transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can you generate sequence numbers without using the sequence generator transformation?
How to differentiate between the active and passive transformations?
define galaxy repository in informatica
Define the various join types of joiner transformation?
have u done any performance tuning? how u ll do?
