| Explanation |
: |
| Update Strategy is a Active and Connected Transformation. |
| Determines whether to insert, delete, update, or reject rows. |
| It flasgs the rows for insert , update , reject or delete .This is used to maintain the historical data in target table. |
| |
| Mapping & Session |
- Within a mapping, you use the Update Strategy transformation to flag rows for insert, delete, update, or reject. When you configue a session, you can set the treat all rows in the sameway ( (as insert).
- If you do not choose Data Driven, the PowerCenter Server flags all rows for the database operation you specify in the Treat Source Rows As option and does not use the Update Strategy transformations in the mapping to flag the rows.
|
| |
| Constants |
| |
Constant |
Value |
| Insert |
DD_INSERT |
0 |
| Update |
DD_UPDATE |
1 |
| Delete |
DD_REJECT |
2 |
| Reject |
DD_REJECT |
3 |
|
| |
| Update Strategy Expressions |
| |
- IIF( Submit Date > Last Date,DD_INSERT, DD_UPDATE)
- 'DD' :: Data Driven
|
| |
| |
|
