Update Records Without using Update Strategy

Update Records Without using Update Strategy


This is very simple procedure.

Create a mapping. There is nothing to do with powercenter designer.

While creating session, we have to change few properties in the session property.

Mapping Designer

Edit Tasks - Properties - Treat Source Rows As - Update

Edit Tasks - Mapping - Update Else Insert  - Select