if i am having 10 records in source, i want 20 records in
target...how will you do it
Answer Posted / jz
drop unique constraint in target table and select only
insert in session target properties run the session twice.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
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 measure objects?
What is an expression transformation in informatica?
What are the types of caches in lookup?
Define enterprise data warehousing?
Can anyone tell me the new features in Informatica 9 Version?
Which files are created during the session rums by informatics server?
What is Session and Batches?
How you know when to use a static cache and dynamic cache in lookup transformation?
what is INFORMATICA TESTING process
Explian the Process of deployment groups in informatica
can u give example for factless fact table
How to extract sap data using informatica? What is abap? What are idocs?
How big was your fact table
What is the need for an etl tool?