Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 4 Answers
- 8338 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
What are pre and post-session shell commands?
How we can use union transformation?
What are the limitations of joiner transformation?
What are the new features of informatica 9.x in developer level?
What is lookup transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What are the various types of transformation?
Explain what is informatica metadata and where is it stored?
What is a node in Informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Write the unconnected lookup syntax?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is difference between a gateway node and worker node?
What is incremental aggregation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
