Create a Reference Table from a Database Table
When you create a reference table from a database table, you connect to the database and import the table data.
Before you import reference table data from a database table, verify that the Informatica domain contains a connection to the database. 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.
Creating a Reference Table from a Database Table
To create the reference table, connect to a database and import the data.
1. Click Design > Reference Table in the Analyst tool.
The New Reference Table wizard appears.
2. Select the option to Connect to a relational table.
3. Select Unmanaged Table to create a table that does not store data in the reference data warehouse.
To perform edit operations on an unmanaged reference table, select the Editable option.
Click Next.
4. Select the database connection from the list of established connections.
Click Next.
5. On the Tables panel, select a table.
6. Verify the table properties in the Properties panel.
Optionally, click Data Preview to view the table data.
Click Next.
7. On the Column Attributes panel, select the Valid column.
Optionally, specify an audit comment to write to the audit trail when a user updates the reference table.
If you create a managed reference table, you can perform the following actions on the Column Attributes panel:
- - Edit the reference table column names.
- - Add a metadata column for row-level descriptions.
8. Click Next.
9. Enter a name and optionally a description for the reference table.
10. In the Folders panel, indicate the project or folder to store the reference table.
The Reference Table panel lists the reference tables in the folder that you select.
11. Click Finish.