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
- 4832 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 materialized view?
What is DR strategy for Informatica project?
What is the difference between a shortcut of an object and copy of an object? Compare them.
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
What is the difference between SOURCE and TARGET BASED COMMITS?
How you can differentiate between connected lookup and unconnected lookup?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
Define joiner transformation?
What is target update override
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
What is the difference b/w natural key and surrogate key
Teradata 
