When you create a managed reference table, you import the column data to the reference data warehouse. When you create an unmanaged reference table, you identify the database table that stores the column data. You can create a managed reference table from an OBDC connection or a native connection. You can create an unmanaged reference table from a native connection.

Before you create the reference table, verify that the Informatica domain contains a connection to the database that contains the reference data. If the domain does not contain a connection to the database, you can define one in the Analyst tool.

To define a database connection, click

Manage

Connections

.