Rules and Guidelines for Reference Tables
Use the following rules and guidelines while working with reference tables in the Analyst tool:
- •When you import a reference table from an Oracle, IBM DB2, IBM DB2/zOS, IBM DB2/iOS, or Microsoft SQL Server database, the Analyst tool cannot display the preview if the table, view, schema, synonym, or column names contain mixed case or lowercase characters.
If the reference table that you are viewing changes in another client, use the Refresh option to reload the reference table and view the changes in the Analyst tool.
To preview data in tables that reside in case-sensitive databases, set the Support Mixed Case Identifiers attribute to true. Set the attribute to true in the connections for Oracle, IBM DB2, IBM DB2/zOS, IBM DB2/iOS, and Microsoft SQL Server databases in the Developer tool or Administrator tool.
- •When you create a reference table from inferred column patterns in one format, the Analyst tool populates the reference table with column patterns in a different format.
For example, when you create a reference table for the column pattern X(5), the Analyst tool displays the following format for the column pattern in the reference table: XXXXX.
- •When you import an Oracle database table, verify the length of any VARCHAR2 column in the table. The Analyst tool cannot import an Oracle database table that contains a VARCHAR2 column with a length greater than 1000.
- •To read a reference table, you need execute permissions on the connection to the database that stores the table data values. For example, if the reference data warehouse stores the data values, you need execute permissions on the connection to the reference data warehouse. You need execute permissions to access the reference table in read or write mode. The database connection permissions apply to all reference data in the database.