The Analyst tool displays the first 100 rows by default when you preview the data for a table. The Analyst tool might not display all the data columns in a wide table.

The Analyst tool can import wide tables with more than 30 columns to profile data. When you import a wide table, the Analyst tool does not display all the columns in the data preview. The Analyst tool displays the first 30 columns in the data preview. However, you can include all the columns in the wide tables and flat files for profiling.

You can import tables and columns with lowercase and mixed-case characters.

You can import tables that have special characters in the table or column name. When you import a table that has special characters in the table or column name, the Analyst tool converts the special character to an underscore character in the table or column name. You can use the following special characters in table or column names:

" $ . + - = ~ ` ! % ^ & * ( ) [ ] { } ' \ " ; : / ? , < > \ \ | \t \r \n

You can import tables and columns with Microsoft SQL92 or Microsoft SQL99 reserved words such as "concat" into the Analyst tool.

You can use an ODBC connection to import Microsoft SQL Server, MySQL, Teradata, and Sybase tables in the Analyst tool. The OBDC connection requires a user name and password.

When you use a Microsoft SQL Server connection to access tables in a Microsoft SQL Server database, the Analyst tool does not display the synonyms for the tables.

When you preview relational table data from an Oracle, IBM DB2, IBM DB2 for zOS, IBM DB2/iOS, Microsoft SQL Server, and ODBC database, the Analyst tool cannot display the preview if the table, view, schema, synonym, and column names contain mixed case or lower case characters. To preview data in tables that reside in case sensitive databases, set the

Support Mixed Case Identifiers

attribute to true in the connections for Oracle, IBM DB2, IBM DB2 for zOS, IBM DB2/iOS, Microsoft SQL Server, and ODBC databases in the Developer tool or Administrator tool.

You can view comments for the source database table after you import the table into the Analyst tool. To view source table comments, use an additional parameter in the JDBC connection URL used to access metadata from the database. In the

Metadata Access String

option in the database connection properties, use

CatalogOptions=1

or

CatalogOptions=3

. For example, use the following JDBC connection URL for an Oracle database connection:

Oracle: jdbc:informatica:oracle:// <host_name>:<port>;SID=<database name>;CatalogOptions=1