My source has 100 records. I have targets say in number 5. all target tables ha

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.

Question Posted / manojdubba

3 Answers
9352 Views
Cognizant, I also Faced
E-Mail Answers

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

i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers TCS,

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers IBM,

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers

How can a transformation be made reusable?

0 Answers Informatica,

What are the types of schemas we have in data warehouse.

0 Answers

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers Logica CMG,

What you know about transaction control transformation?

0 Answers

How do you change parameter when you move it from development to production.

1 Answers

How the informatica server increases the session performance through partitioning the source?

1 Answers

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers HCL,

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers IBM,

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers

For more Informatica Interview Questions Click Here