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 / 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 the reusable transformation?
Explain target update override in informatica
How do you handle two sessions in Informatica
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the modules in Power Center
What is joiner change?
Plz can any one say me how to get the informatica certification materials and dumps
Which transformation should we use to normalise the COBOL and relational sources?
What are the performance considerations when working with aggregator transformation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain sessions. Explain how batches are used to combine executions?
How can you differentiate between powercenter and power map?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the components of the workflow manager?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.