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.

You can configure a database connection in the Connection Explorer. If the Developer tool does not show the Connection Explorer, select

Window

Show View

Connection Explorer

from the Developer tool menu.