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

hi, as al you know, we can set the option in session level
as all rows treat as like insert,update etc., And also we
have update strategy for flaging records as insert,update
etc.. then when we will go for above options and what is
the difference.. explain..

Question Posted / ssrinivas624


hi, as al you know, we can set the option in session level as all rows treat as like insert,update..

Answer / john

Bydefaultly the option in the session properties "Treat
source rows as" is set as Insert.But When we use
Updatestrategy in our mapping, the option in the session
level automatically becomes "Data driven".that means all
the source rows are treated as per the condition you
specified in the updatestrategy transformation.lets say you
have specified as "DD_UPDATE" then integartion service will
treat all the source rows as "UPDATE".
Actually when we use Updatestrategy transformation in
mapping level there is no need of change the settings in
the session level..as i told you earlier the option "Treat
source rows as" is bydefaultly Insert.
But with out using Updatestrategy how wll the Update the
records? or How will you Reject the records? or How will
you Delete the records?
The answer for this Question is...By using the option
called "Treat source rows as"..
so Use this option when you want to update/Reject/Delete
the records with out using the Updatestrategy in mapping
level..

Is This Answer Correct ?    9 Yes 1 No

Post New Answer

More Informatica Interview Questions

Which development components of informatica have the highest usage?

0 Answers  

Differentiate between a database and data warehouse?

0 Answers  

Explain the different lookup methods used in informatica?

0 Answers  

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

what is work of PUSH DOWN option

2 Answers   Wipro,

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

What is the use of source qualifier?

0 Answers  

What is a connected transformation?

0 Answers   Informatica,

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

For more Informatica Interview Questions Click Here
Categories