Using ODI for STARETL Runs

If you are using Oracle Data Integrator (ODI), you must first import the ODI project into your ODI repository. The import process also performs an initial data load and starts the load plans required to support real-time analytics. If you are using multiple data sources with ODI, there is an additional script that needs to be run for each data source. This adds each source into the ODI project, as well as run the initial load and real-time load plans for that data source. The following is a full list of load plans in the Primavera Analytics ODI project:

LOAD_PLAN_INITIAL_LOAD: Initial ETL run, performs a full load of all projects, including those opted in for real-time.
LOAD_PLAN_DAILY: Daily ETL run, performs an incremental update of all scheduled projects.
LOAD_PLAN_REALTIME_PROJECT: Real-time update for project related tables for those projects opted in for real-time.
LOAD_PLAN_REALTIME_GLOBAL: Real-time update for global tables, this scenario runs in a loop.
LOAD_PLAN_ON_DEMAND: A loop that detects any project switched to ETL (either real-time or scheduled).
LOAD_PLAN_LOAD_SINGLE_PROJECT: Load single project (full) from source to STAR database.
LOAD_PLAN_START_JOURNAL: Starts the journal for the data source.
LOAD_PLAN_START_JOURNAL: Stops the journal for the data source.

Related Topics