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

I have a scenario which load the data frm single source to
2 targets as T1, T2, and T1 have a P.K and T2 have F.K
relations. first data has to load in T2, and then data load
to T1 if that record exist in T1... how can we acheive it?

Question Posted / ravikumar2614

Answers were Sorted based on User's Feedback



I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K ..

Answer / babu

Hi raviKumar,

I think u r question has small mistake that is first data
has to load in T1 then only load T2.


By using "Constraint Based load ordering" option u can
achieve this.This option is available in 'Config object'
tab in Session Tabs

(General,Properties,Config
objects,Mapping,Components,Metadata Extensions)

Is This Answer Correct ?    8 Yes 0 No

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K ..

Answer / siva

We have to take the 2 source instances of the same source
say S1 and S2.

Do the mapping from S1 to T1 and then S2 to T2 by making
lookup on T1. i.e. in same mapping 2 different pipelines.

Go to Mapping Tab --> Target Load Plan

It will show the list of two Source Qulifiers.

Then set the Target Load Plan sequence as first SQ1 and then
SQ2. This will first load T1 and then load T2 by making
lookup on T1.

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Informatica Interview Questions

Explain your project of banking domian.

0 Answers   Cap Gemini,

Where can we find the throughput option in informatica?

0 Answers  

How can you complete unrcoverable sessions?

1 Answers  

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

What is a design?

1 Answers  

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

when informatica 8 series released ?

1 Answers   IBM,

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

What do you understand by SOA of Informatica?

0 Answers  

what is the function of 'F10' informatica ?

4 Answers   IBM,

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories