- An option of TARGET instance - The Target table is updated based on Primary Key values. - To update the target table on non-primary key, default query need to be generated. - The Query should override as per the requirement by including a condition in where clause of the default query
- An option available in Source Qualifier and Lookup Transformation - Joins, Filters and Group By and Order By clauses are included to override
By Default the integration service updates the target based on key columns. But we might want to update non-key columns also, at that point of time we can override the UPDATE statement for each target in the mapping. The target override affects only when the source rows are marked as update by an update strategy in the mapping.