source -- sq -- exp1 -- exp2 -- t exp1- create 4 var ports, and 1 output

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..

Question Posted / vidya

4 Answers
8376 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to load the data from people soft hrm to people soft erm using informatica?

962

draw informatica architecture 8.6 ?

3834

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1641

How would you join a node to the already existing domain?

1082

What is a joiner transformation?

948

Explain target update override in informatica

1061

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

997

What is the meaning of up gradation of repository?

1917

What are the tasks that source qualifier perform?

1049

What is the difference between a repository server and a powerhouse?

1431

What are the tasks that can be performed using sq?

1042

what is SDLC way of code development?

1983

tell me about your project functionality

2309

What are the popular informatica products?

969

What is the session task and command task?

1006