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.

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.