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
What is dimensional table? Explain the different dimensions.
How to join three sources using joiner? Explain though mapping flow.
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.
What does cheating measurement mean?
Explain the informatica workflow?
What is meant by query override?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is InformaticaPowerCenter?
What is source qualifier transformation in informatica?
What is an unconnected transformation?
can anyone explain me about retail domain project in informatica?
What are batches?
Explain your project of banking domian.
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