My source has 100 records. I have targets say in number 5.
all target tables has parent and child relationships in
between themselves. Now I want to load all 100 records into
all targets. How U can ensure that record inserted in parent
and then loaded into child.
Answer Posted / rekha
By using constraint load ordering in session level (gofor
config tab -->, then 1st option is constraint based load
ordering) we can achieve this
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to elaborate tracing level?
How can we delete duplicate rows from flat files?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Explain the shared cache and re-cache?
If informatica has its scheduler why using third party scheduler?
how many types of dimensions are available in informatica?
Explain about cumulative Sum or moving sum?
What is a predefined event?
What is decode in informatica?
can we override a native sql query within informatica? How do we do it?
What is a sequence generator transformation?
Explain lookup transformation in informatica
Explain pushdown optimization $pushdownconfig parameter - informatica
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