Answer Detail: RE: Update Strategy

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: Update Strategy

Answer: In which situation do we use update strategy?

October 10, 2009 03:46:04	#8
subbarao_mvs	Member Since: October 2009 Total Comments: 2
RE: Update Strategy
Update Strategy is an active and connected. Generally we use update strategy before target. To Insert or update or delete or reject rows coming from the source to target. The constants we use in update strategy transfromation are: DD_INSERT OR 0 --> INSERTING ROWS DD_UPDATE OR 1 --> UPDATING ROWS DD_DELETE OR 2 --> DELETING ROWS DD_REJECT OR 3 --> REJECTING ROWS