Run the Incremental ETL

  1. Open the Oracle Data Integrator Studio, and click Connect to Repository.

    The Oracle Data Integrator Login dialog box appears.

  2. In the Oracle Data Integrator Login window:
    1. From the Login Name drop-down list, select the Oracle Data Integrator Work Repository name.
    2. In the User field, enter the name of the ODI user.
    3. In the Password field, enter the password for the ODI user.
    4. Click OK.

      The Oracle Data Integrator screen.

  3. From the left pane, select the Operator tab.
  4. Expand the Load Plans and Scenarios section.

    The LP_INC_AM option represents the load plan for the Incremental ETL process for Oracle Argus Mart.

  5. Right-click the LP_INC_AM option, and from the drop-down menu, click Run.

    The Start Load Plan dialog box appears.

  6. Click Run.
  7. In the Start Load Plan screen:
    1. From the Context drop-down list., select CTX_ARGUSMART.
    2. From the Logical Agent drop-down list, select LA_AM.
    3. From the Log Level drop-down list, select a user session task log level.
    4. Click OK.

      The Information dialog box with the Load Plan Started confirmation message appears.

  8. Click OK.

    You can verify the status of the ETL process by navigating to the Load Plan Executions section and expanding the Load Plan folder. You can view the status of the Load Plan in green color with tilted s, which signifies that the ETL session is in progress.

    ETL progress