Create a New Physical Schema

To fetch data by Oracle Data Integrator ETL, you must create a new physical schema.

  1. Select the Topology tab.

    In the Physical Architecture section, under Oracle folder, right-click DS_AM_ARGUSMART.

  2. Select New Physical Schema.

    The Physical Schema screen appears, where Definition is selected by default.

  3. From the Schema drop-down list, select the Argus ETL User (AM_ETL_USER).

    This user was created in Create a Fresh Oracle Argus Mart Schema.

  4. From the Schema (Work Schema) drop-down list, select the Argus ETL User (AM_ETL_USER) again.
  5. From the left-pane, select Context, and click the + icon.

    A new row is added in the empty space below the Context and Logical Schema options.

  6. From the Context drop-down list, select CTX_ARGUSMART.
  7. From the Logical Schema drop-down list, select LS_AM_ARGUSMART.
  8. Click Save on the menu bar.

    The new physical schema appears under Physical Architecture section, in Oracle folder.