CODEWITHSUNDEEP
informaticainformatica-powercenter
Aswin
Aswin

Reputation: 111

How to delete records using update strategy for the target not having PK informatica?

How to delete records using update strategy for the target not having PK informatica?

  1. Set PK in target definition in Informatica even-though if DB doesn't have PK. I am not sure, whether it will work or not.
  2. Create mapping only for delete and in the session property set "treat target rows as" to Delete and choose target table property to "Delete".

Upvotes: 0

Views: 2852

Answers (2)

Leo
Leo

Reputation: 898

You can define primary key on your Target definition. or you can write target override query if you want to update or delete based on non key values.

Upvotes: 0

Samik
Samik

Reputation: 3455

You can set PK in the target definition. It should work.

Upvotes: 0

Related Questions