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 is a joiner transformation and why it is an active one?

798


How do you remove duplicate records in informatica? And how many ways are there to do it?

930


What is the need of an ETL tool?

877


How can we store previous session logs?

816


list out all the transformations which use cache?

911


How to convert multiple rows to single row (multiple columns) in informatica

1156


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

887


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1849


How union transformation is used?

812


Did u used latest transformations of 8.6.0? for what?

1673


Differentiate between router and filter transformation?

825


What are the steps involved in the migration from older version to newer version of Informatica Server?

1860


Under which circumstances, informatica server creates reject files?

856


How many ways are there to create ports?

985


Which means the first record should come as last record and last record should come as first record and load into the target file?

849