Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

What are the new features in Informatica 5.0?

1 Answers  

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

What is an expression transformation?

0 Answers  

Why do we use DSS database for OLAP tools?

2 Answers  

What is informatica? Why do we need it?

0 Answers  

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

How to extract sap data using informatica?

0 Answers  

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

For more Informatica Interview Questions Click Here
Categories