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
When do you use sql override in a lookup transformation?
What is the session task and command task?
Explain the difference between mapping parameter and mapping variable?
How an expression transformation differs from aggregator transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What can we do to improve the performance of informatica aggregator transformation?
Where do we use mapping variables in informatica?
Differentiate between joiner and lookup transformation?
What all join we can perform in LOOKUP transformation?
explan ur project architecture?
What is meant by LDAP users?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain incremental aggregation in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me