Reference Tables
The following changes apply to reference tables in version 9.5.1:
- •Effective in version 9.5.1 you can view metadata properties for a reference table in the Developer tool and Analyst tool. The properties include the data column names, descriptions, precision values, the valid column in the reference table, and the reference database connection name.
Previously, you viewed metadata properties for a reference table in the Analyst tool only.
- •Effective in version 9.5.1, Informatica Data Quality updates the underlying models for reference table metadata in the Model repository.
If you upgrade to version 9.5.1 and open a reference table that you created in an earlier version, the table opens in an unsaved state. Save and close the table to verify the metadata model update. You do not need to open or edit a reference table in an upgraded environment to use the reference table in a transformation.
- •Effective in version 9.5.1, you can assign privileges on the Content Management Service that apply to reference tables. You can assign the following privileges:
- - Create reference tables
- - Edit reference table data
Use the Security tab options on the Administrator tool to assign privileges to users and groups in the domain.
Previously, all users had full access to reference tables.
If you upgrade to version 9.5.1, assign privileges to ensure that users can continue to create and edit reference tables.