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

what is degenerated dimension

6 Answers   Cap Gemini,

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

What are variable ports and list two situations when they can be used?

1 Answers  

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

When do you use sql override in a lookup transformation?

0 Answers  

How to start a workflow using pmcmd command?

0 Answers  

What are the Differences between static cache and dynamic cache?

1 Answers  

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories