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

What is dimensional table? Explain the different dimensions.

938


How to join three sources using joiner? Explain though mapping flow.

911


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1445


What does cheating measurement mean?

828


Explain the informatica workflow?

838


What is meant by query override?

845


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

842


In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1794


What is InformaticaPowerCenter?

917


What is source qualifier transformation in informatica?

769


What is an unconnected transformation?

877


can anyone explain me about retail domain project in informatica?

7731


What are batches?

830


Explain your project of banking domian.

1425


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2371