Tables

In a JOURNAL-type model, a table designates the transactions that have occurred: truncate, insert, update, delete. 

It is possible to integrate the table many times in order to launch different treatments on the same transaction. 

A sequence number indicates a specific treatment sequence.

In an EXTRACT model, as in resume loading, the transaction sequence is always Truncate if the parameter Empty before extraction is set to Yes. There is an insert for every selected line (with the Where clause if available) of the source table.

Refer to section Models if you want to add tables to a model.