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 the difference between writing a joiner query in ANSI style and THETA style?
What is an expression transformation in informatica?
How does a sorter cache works?
How to use pmcmd utility command?
What does refresh system mean, and what are its distinctive choice?
how to load rows into fact table in data warehouse
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is a sorter transformation?
What is resilience time?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
how many types of dimensions are available in informatica?
What are the settings that you use to configure the joiner transformation?
Explain sessions?
How to load the data from people soft hrm to people soft erm using informatica?
What is a passive transformation?