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
- 8539 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
Global and Local shortcuts. Advantages.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
design of staging area?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
According to his methodology what all you need before you build a datawarehouse
scenario where i can use only concurrent execution of workflow.
How can we remove the duplicates from flat file source?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Do you find any difficulty while working with flat files as source and target?
What is a snowflake schema?
While migrating the data from one environment to another environment how would you manage the connections?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the Rank index port in Rank transformation?
How to Create a folder using pmrep command?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
