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
- 4833 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 fact table?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Differences between version 7.x and 8.x.
What are mapplets?
What will be the approach?
What are active transformations.
Define pmcmd command?
Explain how many types of dimensions are available in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How do you remove duplicate records in informatica? And how many ways are there to do it?
How you prepared reports for OLAP?
How do you change a non-reusable transformation to reusable transformation?
Define enterprise data warehousing?
In which transformation you cannot drag ports into it?
What is a repository? And how to add it in an informatica client?
