PowerCenter
- PowerCenter 10.5
- All Products
Property
| Description
|
---|---|
User name
| Database user name.
|
Password
| Password for the user name.
|
Connection String for metadata access
| Connection string to import physical data objects.
Use the following connection string:
jdbc:informatica:oracle://<host>:1521;SID=<sid>
Use the following connection string to connect to Oracle through Oracle Connection Manager:
jdbc:Informatica:oracle:TNSNamesFile=<fully qualified path to the tnsnames.ora file>;TNSServerName=<TNS server name>;
|
Connection String for data access
| Connection string to preview data and run mappings. Enter
dbname.world from the TNSNAMES entry.
|
Code Page
| Database code page.
|
Environment SQL
| Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the connection environment SQL each time it connects to the database.
|
Transaction SQL
| Optional. Enter SQL commands to set the database environment when you connect to the database. The Data Integration Service executes the transaction environment SQL at the beginning of each transaction.
|
Retry Period
| This property is reserved for future use.
|
Parallel Mode
| Optional. Enables parallel processing when loading data into a table in bulk mode. Default is disabled.
|
SQL Identifier Character
| The type of character used to identify special characters and reserved SQL keywords, such as WHERE. The Data Integration Service places the selected character around special characters and reserved SQL keywords. The Data Integration Service also uses this character for the Support Mixed-case Identifiers property.
|
Support Mixed-case Identifiers
| When enabled, the Data Integration Service places identifier characters around table, view, schema, synonym, and column names when generating and executing SQL against these objects in the connection. Use if the objects have mixed-case or lowercase names. By default, this option is not selected.
|