source
file name xyz
a,0,a,a,a
b,b,b,0,b
c,c,c,0,c
target should be like this
xyz
a
b
c
how to implement this?
Answer Posted / dbloc
Based on the data structure, there are 3 rows present. The
clear indicator here is that the last character of each row
does not have a comma.
A sorter (as previously answered will not handle this using
it's DISTINCT option because each row is distinct. The
previous Normalizer answer just baffles me.
Simple answer: Connect to an expression and only connect
the first port of the record to the target.
a
b
c
Keep it simple.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to extract sap data using informatica?
Explain the difference between mapping parameter and mapping variable?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what are 3 tech challenges/ common issues you face?
What are the main features of Oracle 8i with context to datawarehouse?
Explain Dataware house architecture .how data flow from intial to end?
How you prepared reports for OLAP?
explan ur project architecture?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What does update strategy mean, and what are the different option of it?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Is it possible to define a single node as a Gateway node as well as worker node?
Under what conditions selecting sorted input in aggregator will still not boost session performance?