3 ETL Hooks
ETL Hooks are the custom procedures that are used to extend the existing functionality or behavior of the Oracle Argus Mart ETL.
ETL Hooks can be executed to perform actions while fetching data from the source database to the destination database, as required by the users.
The data fetched from Oracle Argus Safety database can be modified before or after uploading the data into the Oracle Argus Martdatabase. You can populate customized (non-standard/user-defined) columns to the standard RM and SM tables. Besides, you can also populate customized table(s).
For more information on populating customized columns or tables, refer to Customize Tables.
ETL Hooks perform these actions at different stages of both initial and incremental ETL.
The Oracle Data Integrator Load Plan lists all the ETL scenarios, as shown below:
For more information, see: