Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4678 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the way to execute pl/sql script using informatica mapping?
Is it possible to revert a global repository to local one and why?
How do you handle two sessions in Informatica
what is degenerated dimension?
Enlist the advantages of informatica.
How can informatica be used for an organization?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How can a transformation be made reusable?
expain about the tune parameters?
How can we handle two sessions in informatica?
Explain sessions?
How do you promote a non-reusable transformation to reusable transformation?
What are the different ways to implement parallel processing in informatica?
what is Active lock explain
What are the new features of Power Center 5.0?
