Update Strategy for Deleting Records in Informatica

Scenario:

I am using an update strategy transformation for deleting records from my target table. In my Warehouse Designer, I have defined one column (say col1) as Primary Key and another column (say col2) as Primary/Foreign Key.

My target has rows like this:

Col1 Col2 Col3
----
1 A value1
2 A value2
3 B value3

I want to delete the record from the target which has the combination (Col1="2" and Col2="A"). Will linking the fields Col1 and Col2 from the Update Strategy transformation to the Target serve the purpose?

Solution:

Define both the columns as primary key in target definition and link only col1 and col2 in mapping. This will serve your purpose.

BTW, if you do only delete then update strategy is not required at all.