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


Please Help Members By Posting Answers For Below Questions

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1987


What is the cumulative sum and moving sum?

962


tell me about your project functionality

2097


Enlist the tasks for which source qualifier transformation is used.

785


Explain lookup transformation in informatica

832


What do you mean by blocking transformation?

781


Explain direct and indirect flat file loading (source file type) - informatica

1081


design of staging area?

1813


How we can use union transformation?

811


without table how to come first record only in oracle?

2046


What are the differences between oltp and olap?

737


What is a stored procedure transformation?

799


According to his methodology what all you need before you build a datawarehouse

1433


What is lookup change?

824


What is standalone command task?

1018