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..
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
The question was on time stamp. what is the difference between HH and HH24 when to use when.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to use pmcmd utility command?
What is InformaticaPowerCenter?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is size of u r database?
What differs when we choose the sorted input for aggregator transformation?
what is the size of your data warehousing?
What is the format of informatica objects in a repository?
r u done any partitions in ur project?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
update strategy transformation in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain what transformation and how many are there in informatica?