Configuration Guide

10.5

Back Next

Importing Column Definitions From Another Table

To import some of the column definitions from another table:

Navigate to the column editor for the table that you want to configure.

Acquire a write lock.

Click the

Import Schema

button.

The Import Schema dialog is displayed.

Specify the connection properties for the schema that you want to import.

If you need more information about the connection information to specify here, contact your database administrator.

Click

The database you enter does not need to be the same as the Informatica ORS that you’re currently working in, nor does it need to be a Informatica ORS.

The only restriction is that you cannot import from a relational database that is a different type from the one in which you are currently working. For example, if your database is an Oracle database, then you can import columns only from another Oracle database.

The Schema Manager displays a list of the tables that are available for import.

Select that table that you want to import.

Click

The Schema Manager displays a list of columns for the selected table.

Select the column(s) you want to import.

Click

Finish

Click the

Save

button to save the column(s) that you have added.

Configuring Columns in Tables

Download Guide