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 sq transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the features of complex mapping?
What is repository manager?
Differentiate between sessions and batches?
How can repository reports be accessed without sql or other transformations?
What is intricate mapping?
Write the prerequisite tasks to achieve the session partition?
How do you use reject loader.
How we can use union transformation?
how to load rows into fact table in data warehouse
Explain the mapping variable usage example in informatica
Explain sessions?
What is the difference between writing a joiner query in ANSI style and THETA style?
Enlist some properties of sessions.