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

how we load the data from source to staging area

4 Answers   TCS,

How many repositories can we create in Informatica?

3 Answers  

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

Which development components of informatica have the highest usage?

0 Answers  

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,




Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

0 Answers  

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

How can informatica be used for an organization?

0 Answers  

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

What are the different versions of informatica?

0 Answers  

What is limitations of truncate and load option

1 Answers   Cap Gemini,

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories