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 / naveen
Use the target load plan & constriant based loading order in
session level and set the dependency
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is complex mapping?
While migrating the data from one environment to another environment how would you manage the connections?
What is the status code in stored procedure transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What does role playing dimension mean?
How might one distinguish in the case of mapping is right or not without associating session?
Difference between Target-based loading and constraint-based loading?
What is InformaticaPowerCenter?
what is the difference between informatica6.1 and infomatica7.1
Can we create two repositories on same database instance in oracle?
What is the commit type if you have a transaction control transformation in the mapping?
how we can load rejected record's at run time?(not through bad files)
waht type of interface is used for testing the data in 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
What are the conditions needed to improve the performance of informatica aggregator transformation?