Audit framework

Use this framework to add to each row the value updated, the value before and a flag (F_) that marks the update.

1. From the window called Adding tables to the model, select Audit in the list.
2. Select the table(s) and click Ok.
3. 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.
   
4. Click Finish.
5. If needed, use the transformation tool to check the aggregations added, to edit them or to add a lookup.
6. Follow Preparing the replication procedure starting from step 4, then Operating a replication.