List of Oracle Argus Mart ETL Hooks

Oracle Argus Mart comprises the following ETL Hooks that can be executed at different stages:

• CUSTOM ROUTINE BEFORE STAGE TABLES POPULATION—Execute before populating the Staging tables.

• CUSTOM ROUTINE BEFORE REPORTING TABLES POPULATION—Execute before populating the Reporting tables (or RM tables).

• CUSTOM ROUTINE AFTER REPORTING TABLES POPULATION—Execute after populating the Reporting tables (or RM tables).

• CUSTOM ROUTINE BEFORE SIGNAL HELPER TABLES POPULATION—Execute before populating the Signal Helper tables.

• CUSTOM ROUTINE AFTER SIGNAL HELPER TABLES POPULATION—Execute after populating the Signal Helper tables.

• CUSTOM ROUTINE AFTER ETL—Execute after running the initial or incremental ETL (post-ETL commit).

Note:

ETL hooks CUSTOM ROUTINE BEFORE SIGNAL HELPER TABLES POPULATION and CUSTOM ROUTINE AFTER SIGNAL HELPER TABLES POPULATION are executed only when any case revision is being processed for SM tables in the current ETL run.