2. ETL Server

ETL (Extract, Transform, Load) solution for Oracle Global Trade Intelligence is offered using the Oracle Data Integrator tool only.

This chapter details the technical solution of the Oracle Global Trade Intelligence ETL in Oracle Data Integrator.

Projects

The Oracle Global Trade Intelligence ETL solution is delivered under a single Oracle Data Integrator project called FTI_ETL. The ETL process works as follows:

• When the ETL process runs for the first time, initial load is executed for a ‘first time load’ when no data exists in the HD tables. Typically, the execution plan in this mode involves only inserts to the HD tables.
• Any other time the ETL process runs, incremental load is executed for regular operational data load to the HD tables. Typically, the execution plan in this mode involves inserts, updates, and soft deletes to HD tables.

Models

The FTI_ETL project ships the following logical models:

• ORACLE_FTI: This model describes the complete schema of the target database application (i.e. HDOWNER/Historical Database).
• ORACLE_GTM: This model describes the complete schema of the source database application (i.e. GLOGOWNER/GTM Database).