we just need to change the session level property for "Treat Source Row as" to –> Update.
Also we need make changes to the Mapping property to check "INSERT" and "Update else Insert" boxes of the target to achieve this.
Drawback:
using update strategy we can inactive an existing record and insert new record, with above approach(with out update strategy) we can not inactive an existing record based on an incoming record from source however we can update an existing one and insert a new one.
Also we need make changes to the Mapping property to check "INSERT" and "Update else Insert" boxes of the target to achieve this.
Drawback:
using update strategy we can inactive an existing record and insert new record, with above approach(with out update strategy) we can not inactive an existing record based on an incoming record from source however we can update an existing one and insert a new one.
Comments
Post a Comment