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
What is a joiner transformation and why it is an active one?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the need of an ETL tool?
How can we store previous session logs?
list out all the transformations which use cache?
How to convert multiple rows to single row (multiple columns) in informatica
How identifying bottlenecks in various components of informatica and resolving them?
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
How union transformation is used?
Did u used latest transformations of 8.6.0? for what?
Differentiate between router and filter transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Under which circumstances, informatica server creates reject files?
How many ways are there to create ports?
Which means the first record should come as last record and last record should come as first record and load into the target file?