What is the functionality of update strategy?

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

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,


What is the command used to run a batch?

0 Answers  


how to run the batch using pmcmd command

2 Answers   Wipro,


What are the join types in joiner transformation?

1 Answers   Informatica,


my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 Answers   Zensar,






What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,


How to create Target definition for flat files?

0 Answers   Informatica,


what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  


What is main use of mapplet?

0 Answers  


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

0 Answers   TCS,


What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  


What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  


Categories