UPDATE STRATEGY Transformation

UPDATE STRATEGY Transformation

1. ACTIVE

2. Setting Update Strategy

   • within session
     • all rows are flagged insert, delete, or update on a target by target basis
       • Update as Update Update as Insert Update else Insert
     • if Data Driven set - IS will follow Update Strategy Transformation
     • If Data Driven not set and Update Strategy in mapping - warning from Workflow
   • within mapping - Data Driven
     • update strategy expression
       • DD_INSERT DD_UPDATE DD_DELETE DD_REJECT
         • IIF or DECODE
           • IIF( (A > B), DD_REJECT, DD_UPDATE)
           • DECODE(item, 'Pen', 10, 'Pencil, 2, 'Eraser', 3,0)
     • Rejected Rows Strategy
       • Forward Rejected Rows
         • YES
           • forward to next transformation by default - writes rows to the session reject file
         • NO
           • Drops rows - writes them to the session log file
       • If row error handling enabled
         • writes rejected and dropped rows to error logs, no reject file

3. controls how rows are flagged for Insert, Update, Delete, or Reject for the same target

4. Aggregator before Update Strategy

5. Lookup and Update Strategy

   • if dynamic lookup cache - must use Update Strategy
     • Session properties Treat Rows As - Data Driven
       • must define update strategy for target table in session