I've a denormalized table
EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to
insert the record into target in the format that, there will
be 2 target rows for 1 source record. In target the row
needs to be inserted as:
ROW1: empno,ename,addr1,phone
ROW2: empno,ename,addr2,fax,email

And I'm not allowed to normalize transformation. How to achieve?



I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert ..

Answer / rampriya

We can have two target instance of the same table. Load the
first row1 to 1st instance and row2 to 2nd instance.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Informatica Interview Questions

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  


What is joiner transformation in informatica?

0 Answers  


What is batch and describe about types of batches?

2 Answers  


can u any challenge your project?

0 Answers   HP,


write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  






What are the limitations of joiner transformation?

0 Answers   Informatica,


What is xml source qualifier transformation in informatica?

0 Answers  


What is intricate mapping?

0 Answers  


Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,


What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  


What is the Rank index port in Rank transformation?

0 Answers   Informatica,


draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,


Categories