Selecting Source Columns

Use source columns to specify the columns that are available for mapping in the import format. There is no validation of the table or column names in this section - the source columns are registered so that they are available in import format for mapping.

Adding Source Columns

The source columns added in this section must match the columns specified in the data model for the source table in the Oracle Data Integrator.

  To add a source column:

  1. In the Tasks pane, under Setup, select Source Adapter.

    The Source Adapter screen is displayed.

    Select the Source Column tab.

  2. From the Source Column task bar, select Add.

    Entry fields appear for the Column Name, Table Name, and Display Name columns.

  3. In Column Name, enter the source column name.

    For example, enter “SEGMENT1”. The source column name must have a corresponding column name in the ODI model.

  4. In Table Name, enter the table name.

    For example, enter “LOGICAL_BALANCES”. The table name must have a corresponding table name in the ODI model.

  5. In Display Name, enter the display name used for the Import format.