Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
Choose Unicode if non-ASCII characters have to be moved. Otherwise, choose
ASCII. The Data Movement Mode option is configurable and can be reset after
To set the Data Movement Mode, log into Informatica Administrator, select the
Integration Service, then click the Properties tab, then display the General
Properties tab, and set the DataMovementMode value.
Determining code pages for Informatica PowerCenter components.
to source and target code pages, Informatica PowerCenter uses code pages for
PowerCenter Client, the Integration Service, the Informatica Repository, and
PowerCenter command line programs (pmcmd and pmrep, which are used by
DAC to communicate with PowerCenter Services).
Carefully review the section "Understanding Globalization" (Chapter 22 in the
book version) in the Informatica PowerCenter Administrator Guide, particularly if
your environment requires the Data Mode Movement mode to be set to
UNICODE. The section discusses code page compatibility and code page
requirements for the Informatica components.
Setting environment variables.
You must manually set the appropriate
environment variables for UNIX environments. In addition, the Informatica
installer requires the appropriate locale to be set on UNIX machines. Use LANG,
LC_CTYPE or LC_ALL to set the UNIX code page. For more information, see the
topic titled "Configuring Environment Variables," in "Chapter 2: Before You
Install," in the PowerCenter Installation and Configuration Guide.
If your environment uses Oracle or DB2 database, you need to set the environment
variables NLS_LANG or DB2CODEPAGE. For information on how to set these
environment variables see
Section 18.104.22.168, "How to Set the NLS_LANG
Environment Variable for Oracle Databases"
Section 22.214.171.124, "How to Set the
DB2CODEPAGE Environment Variable for DB2 Databases."
Configuring Relational Connections. When you configure relational connections in
the Workflow Manager, choose a code page that is compatible with the code page
of the database client. If you set a database environment variable to specify the
language for the database, ensure the code page for the connection is compatible
with the language set for the variable. For example, if you set the NLS_LANG
environment variable for an Oracle database, ensure that the code page of the
Oracle connection is identical to the value set in the NLS_LANG variable.
For more information about data movement modes, refer to the Informatica
4.4 Preinstallation Tasks
This section explains the mandatory preinstallation tasks that you must perform for an
Oracle BI Applications deployment. It contains the following topics:
Section 4.4.1, "Create Databases for Oracle BI Applications and Informatica
Section 4.4.2, "Install and Configure Database Connectivity Software"
Section 4.4.3, "Perform Prerequisites for Informatica PowerCenter Installation"