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
- 4730 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 |
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
what is distinct
What are the types of schemas we have in data warehouse.
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
What is a design?
waht type of interface is used for testing the data in informatica
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
diffrence between command task and control task
what is the difference between mapplet & stored procedure?
What are the different threads in DTM process?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
Can anyone tell me the new features in Informatica 9 Version?
Teradata 
