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

Identifier Properties in Database Connections

Identifier Properties in Database Connections

When you create most relational database connections, you must configure database identifier properties. The identifier properties determine whether the Data Integration Service encloses identifiers within delimited characters when the service generates SQL queries to access the database.
A database identifier is a database object name. Tables, views, columns, indexes, triggers, procedures, constraints, and rules can have identifiers. You use the identifier to reference the object in SQL queries. A database can have regular identifiers or delimited identifiers that must be enclosed within delimited characters.

0 COMMENTS

We’d like to hear from you!