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 are the tasks that source qualifier perform?
Repository user profiles
How to create Target definition for flat files?
How we can create indexes after completing the load process?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
what are the deliverables?in your project?
What are the components of workflow manager?
What do you understand by SOA of Informatica?
Define update strategy?
Write the unconnected lookup syntax?
Explain sessions and how many types of sessions are there?
which one is better performance wise joiner or look up
How can we improve session performance in aggregator transformation?
What are multi-group transformations?