Search code examples
etlinformatica-powercenter

Row Type Update Strategy - Informatica Power Center

I have a problem in the transformation mapping for Update Strategy.

I have the transformation depending if it comes in the ' CHANGE_TYPE ' field will then updated , inserted or deleted.

But the review is a field called << ROW TYPE >> does not correspond to the transformation

PowerCenter

PowerCenter 2

Solution

  • Check the session's properties at the Workflow level. In Workflow Manager, edit the session, under the "Properties" tab, find the row Treat source rows as, and be sure you have set the value to Data Driven.
    If it hasn't been set to Data Driven, then the Integration Service will not follow your directions in the Update Strategy expression.

    Properties tab