When you need to update a huge table with few records and less inserts. The solutions for such situations is to use Lookup Transformation and Update Strategy to insert and update records. The Lookup Transformation may not perform better as the lookup table size increases and it also degrades the performance. This mapping gives a better solution for such situations, that we can update records without using Update Strategy and Lookup transformation and it enhances the session performance. ScenarioWe create a mapping without using Lookup transformation and Update Strategy. The mapping consists of the source table as CUSTOMER_INFO and the target table as CUSTOMER_INFO_TGT.The CUSTOMER_INFO table has records which need to insert if record is not present and update if records are already present in the CUSTOMER_INFO_TGT table. Configuration TasksWe need to edit session task properties to update and insert records in the target table in such way that session have the capability to perform both update and insert.

• Edit session configuration under the properties tab of Edit Tasks. Set Treat source row as an update.
• Under Mapping tab set target table properties shown below. Choose Insert and Update else Insert check boxes.

These options will make the session as Update and Insert records without using Update Strategy in Target Table.