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?
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 |
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)
What is joiner transformation in informatica?
What is batch and describe about types of batches?
can u any challenge your project?
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.
What are the limitations of joiner transformation?
What is xml source qualifier transformation in informatica?
What is intricate mapping?
Why we select the table which has minimum number of records as Master table in joiner?
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
What is the Rank index port in Rank transformation?
draw informatica architecture 8.6 ?