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

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

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

1 Answers  

What is data caches/ index caches?

0 Answers  

How to eliminate duplicates from flat file..what is the procedure

4 Answers  

which one is better performance wise joiner or look up

0 Answers   Informatica,

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,

What all join we can perform in LOOKUP transformation?

0 Answers  

What is hash partition?

2 Answers  

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories