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
- 4034 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 meant by query override?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what is the -ve test case in your project.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is sequence generator transformation in informatica?
Reusable transformation and shortcut differences
If informatica has its scheduler why using third party scheduler?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the issues you have faced in your project? How did you overcome those issues?
What is depict expression change?
what is SDLC way of code development?
How to elaborate powercenter integration service?
What is mapplet in informatica?
What differs when we choose the sorted input for aggregator transformation?
