Comparison between an express-mode and a deluxe-mode load operation
The following table contrasts the operation of an express-mode
and a deluxe-mode operation.
| Express® mode action | Performed by | Deluxe mode action | Performed by |
|---|---|---|---|
| Set objects to disabled | onpload | Set constraints to filtering | onpload |
| Load records from the data file into the table (including rows that would cause violations if constraints were on) | onpload | Load records from data file into the table. Write records that violate constraints into the violations table and not into the target table | onpload |
| Enable objects. Detect violators and copy them into the _vio table. | onpload | Set constraints to non-filtering | onpload |
| Complete a level-0 backup to make the database writable | user | ||
| Resolve violators | user | Resolve violators | user |