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 / rajesh

use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the tasks that source qualifier perform?

838


Repository user profiles

1574


How to create Target definition for flat files?

988


How we can create indexes after completing the load process?

926


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

854


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

846


what are the deliverables?in your project?

1894


What are the components of workflow manager?

808


What do you understand by SOA of Informatica?

760


Define update strategy?

828


Write the unconnected lookup syntax?

841


Explain sessions and how many types of sessions are there?

798


which one is better performance wise joiner or look up

853


How can we improve session performance in aggregator transformation?

893


What are multi-group transformations?

797