Setting Target Update Strategy

You can set the way target metadata is updated when you map source to target. You can update the strategy any time as per your requirement.

To set target update strategy, follow these steps:

  1. In the Additional Mapping Information pane, click the Target Update Strategy tab.
  2. Click .
  3. Click the appropriate update strategy from the options and enter Update Strategy Description.

    4. For example:

    • Update strategy: Insert else Update
    • Update Strategy Description: Insert the source column value to a blank target column else update the target column value with the source column value.
  4. Click .

    5. The Target Update Strategy is set.