Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Analyst
  3. Library Workspace
  4. Connections Workspace
  5. Job Status Workspace
  6. Projects Workspace
  7. Model Repository
  8. Data Objects
  9. Search
  10. Appendix A: Configure the Web Browser

Analyst Tool Guide

Analyst Tool Guide

Example: Database Uses Case-Sensitive Identifiers

Example: Database Uses Case-Sensitive Identifiers

In this example, the database uses case-sensitive identifiers. The database might use keywords or special characters in some identifiers, or it might not.
In the database connection, configure the identifier properties as follows:
  1. Set the
    SQL Identifier Character
    property to the character that the database uses for delimited identifiers.
    This example sets the property to
    "" (quotes)
    .
  2. Select the
    Support Mixed-case Identifiers
    property.
When the Data Integration Service generates SQL queries, the service places the selected character around all identifiers. For example, the Data Integration Service generates the following query:
SELECT * FROM "MyTable" /* case-sensitive identifier enclosed within delimited character */ WHERE "MYCOLUMN" = 10 /* regular identifier enclosed within delimited character */

0 COMMENTS

We’d like to hear from you!