Use this framework to add to each row the value updated, the value before and a flag (F_) that marks the update.
Procedure
- From the window called Adding tables to the model, select Audit in the list.
- Select the table(s) and click Ok.
-
In the window displayed, select the columns as well as their options.
- The first columns are technical ones.
- DD_ACTION cannot be unselected, as no other column could be added if the insert/update/delete transactions were not included.
- For the other columns, you can select or deselect the value updated, the value before and the flag.
- Click Finish.
- If needed, use the transformation tool to check the aggregations added, to edit them or to add a lookup.
- Follow Preparing the replication procedure starting from step 4, then Operating a replication.