Update Strategy Transformation – My Notes
How rows are flagged for insert, update, delete, or reject within a mapping?
Ans:- Using Update Strategy transformation. We can also use the Custom transformation to flag rows for insert, delete, update, or reject.
What are the different levels we can configure update strategy?
Ans:- (1) Within a session, (2) Within a mapping.
What are the constants used in update strategy expression?
Ans:- DD_INSERT (0), DD_UPDATE (1), DD_DELETE (2), DD_REJECT (3), The Integration Service treats any other value as an insert.
What action will take on Rejected Rows?
Ans:- By default, the Integration Service forwards rejected rows to the next transformation. If you disable the option ” The Integration Service flags the rows for reject and writes them to the session reject file.
What would be the result if we enable ‘Row error handling’?
Ans:- The Integration Service writes the rejected rows and the dropped rows to the row error logs. It does not generate a reject file.
How to configure a single database operation for all rows in Update Strategy for a Session?
Ans:- Select an option from ‘Treat Source Rows As’ (1) Insert – Treat all rows as inserts. (2) Update – Treat all rows as updates. (3) Treat all rows as deletes. (4) Data Driven – Integration Service follows instructions coded into Update Strategy and Custom transformations.
What would be the default value for ‘Treat Source Rows As’ If the mapping for the session contains an Update Strategy transformation?
Ans:- Data Driven – If you do not choose Data Driven when a mapping contains an Update Strategy or Custom transformation, the Workflow Manager displays a warning.
What would be the result of a session with an update Strategy but without selecting ‘Treat Source Rows As’ data driven?
Ans:- The Integration Service does not follow instructions in the Update Strategy or Custom transformation in the mapping to determine how to flag rows.
What are the session properties of update strategy Operations for Individual Target Tables?
Ans:- We can set the following update strategy options: Insert, Delete, ‘Update as Update‘ (Update each row flagged for update if it exists in the target table), ‘Update as Insert‘ (Insert each row flagged for update), ‘Update else Insert‘ (Update the row if it exists. Otherwise, insert it), Truncate table.