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

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,

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

3 Answers  

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh

5 Answers   Accenture,

How would you copy the content of one repository to another repository?

0 Answers  

What is a passive transformation?

0 Answers   Informatica,

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,

Is it possible to revert a global repository to local one and why?

0 Answers  

For more Informatica Interview Questions Click Here
Categories