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 primary and backup node?
Differentiate between a repository server and a powerhouse?
What is Data Caches size?
What are the databases that informatica can connect to windows?
Mention a few design and development best practices for informatica?
Plz can any one say me how to get the informatica certification materials and dumps
Mention few advantages of router transformation over filter transformation.
Explain why we use partitioning the session in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How many input parameters can exist in an unconnected lookup?
Define mapping and session?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain about Informatica server process that how it works relates to mapping variables?
What is enterprise data warehousing?
Write the advantages of partitioning a session?