I have source like col1,col2,col3,col4 and the values are like
3,6,1,7
1,5,3,8
2,1,5,6
i want the output like
3,6,7
5,3,8
2,5,6
How we will achieve in this scenario in informatica level.
Please help me..
Thanks in advance..
Answers were Sorted based on User's Feedback
Answer / vidya
source -- sq -- exp1 -- exp2 -- t
exp1- create 4 var ports, and 1 output port as
v1=iif(col1=1, null, c1)
v2=iif(col2=1, null, c2)
v3=iif(col3=1, null, c3)
v4=iif(col4=1, null, c4)
op_port1=v1||v2||v3||v4
exp2- op_port1
create 3 out_put port
c1=substr(op_port1, 1,1)
c2=substr(op_port1, 2,1)
c3=substr(op_port1, 3,1)
Is This Answer Correct ? | 10 Yes | 0 No |
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
how many session run unix environment what command using ?
how to load only the first and last record of a flat file into the target?
what is inline view?
Can you copy the session to a different folder or repository?
What is the Rankindex in Ranktransformation?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
What is informatica?
which is better perfomancewise lookup or joiner and why?can anyone give example?
How can you run a session without using server manager?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?