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?
- 1 Answers
- 4056 Views
- IBM, I also Faced
- E-Mail Answers
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 |
what is persistant cache in which situation we will use persistantcache
what are the types of facts with Examples?
In operator is used in which transformation in informatica 8.6.0
what are the settiings that u use to cofigure the joiner transformation?
When will you use SQL override in a lookup transformation?
How do you handle decimal places while importing a flatfile into informatica?
Explain informatica architecture - version 8 / 9
what are the transformations that restricts the partitioning of sessions?
What are the types of caches in lookup?
How the informatica server increases the session performance through partitioning the source?
HOW DO YOU CONNECT TO REMOTE SERVER ?
How mapping parameter and variable works
Teradata 
