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. On the Setup tab, under Register, select Source Adapter.
2. In Source Adapter, select the Source Column tab.
3. From the Source Column task bar, select Add.

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

4. 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.

5. 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.

6. In Display Name, enter the display name used for the import format.