What is up date strategy and what are the options for update strategy?

What is up date strategy and what are the options for update
strategy?

Question Posted / swetha

2 Answers
9663 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is up date strategy and what are the options for update strategy?..

Answer / jyothi

Update strategy is used for flagging the records by using
the options insert/update/delete/reject.
Update strategy is used in two levels.
session level:at session level we have to use the options
update as insert,update as update,update else insert.
mapping level:at mapping level we have to use the options
dd-insert,dd-update,dd-reject,dd-delete.

Is This Answer Correct ?

7 Yes

0 No

What is up date strategy and what are the options for update strategy?..

Answer / mkolari

We can use update strategy at two different levels
1) within a session :- When you are configuring a
session you can give instructions to treat a)all rows as
insert b)all rows as update c)data driven (use instructions
coded into the session mapping to flag rows for different
database operations.)

2) within mapping :- You can flag rows for
insert,update,delete or reject.
Don't forget to set "Treat source rows as" to Data Driven
in the session properties if you are flagging rows within
the mapping.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer