Oracle^® Business Intelligence Applications Installation and Configuration Guide > Preinstallation and Predeployment Considerations for Oracle BI Applications >

Deploying Oracle Business Analytics Warehouse in Latin-1 General, Unicode and Non-English Environments

This section describes the different settings for Informatica servers and databases when deploying the Oracle Business Analytics Warehouse in Latin-1 General, Unicode, and non-English environments. When you configure Informatica, the Informatica repository, and the databases, you will need to refer to this section.

NOTE:  If you are installing the Oracle Business Analytics Warehouse in a UNIX environment, you must use the Unicode character data mode.

The Oracle Business Analytics Warehouse can be deployed in various code page environments to support global deployments. The following source and data warehouse configurations are supported:

• Latin-1 General (7-bit ASCII) to Latin-1 General (7-bit ASCII). 7-bit ASCII is the character set used for English. See Source and Data Warehouse Code Pages for Latin-1 General (7-bit ASCII) to Latin-1 General (7-bit ASCII).
• Latin-1 General (8-bit ASCII) to Latin-1 General (8-bit ASCII). 8-bit ASCII is the character set used for Western European languages that use accented Roman characters. See Source and Data Warehouse Code Pages for Latin-1 General (8-bit ASCII) to Latin-1 General (8-bit ASCII).

  NOTE:  You must run the Informatica Server in Unicode mode if your source data contains multibyte or ISO 8859-1 (8-bit ASCII) data. For instructions on setting the data movement mode to Unicode, see To set up the Informatica Server in Informatica PowerCenter.

• Unicode to Unicode. See Source and Data Warehouse Code Pages for Latin-1 General (8-bit ASCII) to Latin-1 General (8-bit ASCII).
• Code page (multi- or single-byte) to Unicode. See Source and Data Warehouse Code Pages for Code Page to Unicode.
• Code page to code page (where the code pages are the same). See Source and Data Warehouse Code Pages for Code Page to Code Page.

The following environment variables need to be set before you begin the installation process:

• NLS_LANG (for Oracle). For instructions, see Setting the NLS_LANG Environment Variable for Oracle Databases.
• DB2CODEPAGE (for DB2). For instructions, see Setting the DB2CODEPAGE Environment Variable for DB2 Databases.

The following environment variable needs to be set during the configuration process:

• Informatica Server Data Movement. For instructions, see To set up the Informatica Server in Informatica PowerCenter.