4 ETL Extensibility

Custom Routines are the configured procedures that are executed during Oracle Argus Insight Incremental ETL to perform custom actions.

Oracle Argus Insight supports the following custom routines:

  • PRE_INCREMENTAL_ETL_TASK - Executes the configured routine during incremental ETL before population of Oracle Argus Insight staging tables.
  • POST_INCREMENTAL_ETL_TASK - Executes the configured routine during incremental ETL after population of Oracle Argus Insight mart tables.

These custom routines are useful in the following scenarios:

  • Populating custom tables or new columns based on the business needs.
  • Analyzing tables with huge data.
  • Triggering an event based on ETL completion for the use with other custom products.

For more information, see: