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 functionality of update strategy?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is the functionality of update strategy?..

Answer / sivaprasad

Update strategy defines the sources to be flagged for
insert, update,
delete, and reject at the targets.
What are update strategy constants?
DD_INSERT,0 DD_UPDATE,1 DD_DELETE,2
DD_REJECT,3

If DD_UPDATE is defined in update strategy and Treat source
rows as INSERT in Session . What happens?
Hints: If in Session anything other than DATA DRIVEN is
mentions then Update strategy in the mapping is ignored

Is This Answer Correct ?    6 Yes 0 No

What is the functionality of update strategy?..

Answer / chluff12

to decide to insert, update, delete or reject the data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

performance wise which one is better in joiner and lookup transformation

2 Answers  

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

which one is better either active or passive transformation in informatica

1 Answers  

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

Explain incremental aggregation in informatica

0 Answers   Informatica,

What are the basic needs to join two sources in a source qualifier?

4 Answers  

For more Informatica Interview Questions Click Here
Categories