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

Insert else update option in which situation we will use

Question Posted / sunil.knl

Answers were Sorted based on User's Feedback



Insert else update option in which situation we will use..

Answer / mike

as per my knowledge
when we use update strategy transformation we will come
across to use this...insert else update...
let us suppose we have two tables a and b. a is the source
table and b is the target table...let us take b which is
target table contains some matched records with 'a' which
is source table. If source table 'a' is modified and
inserted with some records,here we need to update the
records in the target table...therefore by using the insert
else update option in the session properties of target we
can insert new records and update the existing records

correct me if i was wrong

Is This Answer Correct ?    4 Yes 0 No

Insert else update option in which situation we will use..

Answer / sushma

We set this property when the lookup TRFM uses dynamic
cache and the session preperty TREAT SOURCE ROWS
AS "Insert" has been set.

Is This Answer Correct ?    0 Yes 0 No

Insert else update option in which situation we will use..

Answer / naveen

This option we use when we want to maintain the history.

if records are not availabe in target table then it inserts
the records in to target and records are available in
target table then it updates the records.

Regards,
Naveen

Is This Answer Correct ?    0 Yes 0 No

Insert else update option in which situation we will use..

Answer / madhavi

if the source table contain multiple records .if the record specified in the associated port to insert into lookup cache. it does not find a record in the lookup cache when it is used find the particular record & change the data in the associated port.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

how can u tune u r informatica mapppings

2 Answers   CTS,

. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null

3 Answers  

What is a pre-defined event and user-defined event?

0 Answers  

Describe expression transformation?

0 Answers  

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

What are the different threads in DTM process?

2 Answers  

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories