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


Please Help Members By Posting Answers For Below Questions

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

776


What is rank index in rank transformation?

828


how to create user defined function (udf) in informatica

1050


How will the document be delivered to me?

847


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2371


What are session parameters ? How do you set them?

1603


How identifying bottlenecks in various components of informatica and resolving them?

880


Can anyone tell me the new features in Informatica 9 Version?

1807


How can we remove the duplicates from flat file source?

812


What is powercenter on grid?

962


What is a code page?

931


Explain where to store informatica rejected data? How to extract the informatica rejected data?

841


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1843


Differentiate between reusable transformation and mapplet.

878


server hot-ws270 is connect to Repository B. What does it mean?

2175