What is the meaning of the below expression in update strategy? IIF( SKU_ID = 100000, 1,2)
-
IIF( SKU_ID = 100000, DD_UPDATE, DD_DELETE)
-
IIF( SKU_ID = 100000, DD_INSERT, DD_UPDATE)
-
IIF( SKU_ID = 100000, DD_DELETE, DD_REJECT)
-
IIF( SKU_ID = 100000, TRUE, FALSE)
Update Strategy uses numeric constants: DD_INSERT=0, DD_DELETE=1, DD_UPDATE=2, DD_REJECT=3. The IIF returns 1 (DD_UPDATE) when SKU_ID equals 100000, and 2 (DD_DELETE) otherwise, perfectly matching option A's description.
In an Informatica PowerCenter Update Strategy transformation, row-level update codes are represented by numeric constants: DD_INSERT = 0, DD_UPDATE = 1, DD_DELETE = 2, and DD_REJECT = 3. The expression IIF(SKU_ID = 100000, 1, 2) therefore tags matching rows with the update code (1) and non-matching rows with the delete code (2), which is exactly IIF(SKU_ID = 100000, DD_UPDATE, DD_DELETE).