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.

Answers were Sorted based on User's Feedback



My source has 100 records. I have targets say in number 5. all target tables has parent and child r..

Answer / veeru

use the constrinat based loading order in session level and
set the dependency

Is This Answer Correct ?    15 Yes 0 No

My source has 100 records. I have targets say in number 5. all target tables has parent and child r..

Answer / 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

My source has 100 records. I have targets say in number 5. all target tables has parent and child r..

Answer / 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

More Informatica Interview Questions

Informatica settings are available in which file?

0 Answers   Informatica,


how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,


Where do you create/define mapping parameter and mapping variable?

1 Answers  


What are the phases in SDLC?

3 Answers  


Mapplets can you use an active transformation in a mapplet,

1 Answers  






expain about the tune parameters?

0 Answers   TCS,


what is the size of u r source(like file or table)?

0 Answers   HP,


What are the tuning techniques you applied during your last project

0 Answers  


Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,


i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  


what are presession,postsession success and postsession failure commands ?

1 Answers  


What is informatica? What exactly are the practical uses in real world

2 Answers  


Categories