How do you convert single row from source into three rows into target?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,


hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,


Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,


What are the types of data warehouses?

0 Answers   Informatica,






Explain the code page compatibility?

0 Answers  


what are challenges that you faced in testing? give solution to it?

1 Answers  


All active transformations r passive or not?

7 Answers  


how to duplicates from expression transformation without using sorter before that

1 Answers  


if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


Differentiate between sessions and batches?

0 Answers  


Categories