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

what is the necessity to use update strategy?(except for
updates)

Question Posted / mehul.thakur

Answers were Sorted based on User's Feedback



what is the necessity to use update strategy?(except for updates)..

Answer / gazulas

man!! u can flag the record as insert or reject.

Is This Answer Correct ?    2 Yes 0 No

what is the necessity to use update strategy?(except for updates)..

Answer / raghav

Following options are available for update strategy :

DD_INSERT : If this is used the Update Strategy flags the row for insertion. Equivalent numeric value of DD_INSERT is 0.
DD_UPDATE : If this is used the Update Strategy flags the row for update. Equivalent numeric value of DD_UPDATE is 1.
DD_DELETE : If this is used the Update Strategy flags the row for deletion. Equivalent numeric value of DD_DELETE is 2.
DD_REJECT : If this is used the Update Strategy flags the row for rejection. Equivalent numeric value of DD_REJECT is 3.

so u can use update strategy for delete, reject or insert.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the various types of transformation?

0 Answers  

What do you understand by SOA of Informatica?

0 Answers  

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

What is the difference between bitmap and btree index?

2 Answers   CTS, TCS,

How to delete the data in the target table after loaded.

3 Answers   TCS,

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

What is an expression transformation in informatica?

0 Answers  

Explain lookup transformation source types in informatica

0 Answers   Informatica,

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

What are the rank caches?

2 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories