Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers  

Different types of Power center errors?

1 Answers   Cinterco, IBM,

performance wise which one is better in joiner and lookup transformation

2 Answers  

What is a filter transformation?

0 Answers  

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

how to remove staging area

1 Answers  

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

Which files are created during the session rums by informatics server?

0 Answers  

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

r u done any partitions in ur project?

0 Answers   TCS,

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories