Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Deploying Informatica and Siebel Data Warehouse in Unicode and Non-English Environments >

Code Page (Multibyte/Single-Byte) to Unicode Parameter Settings for Siebel Data Warehouse

---

For installation on multibyte code page environments, the data warehouse setup requires two operating system environments: one for the Informatica Repository Server and one for the Informatica Server.

Table 8 shows the DBMS settings for an environment with a Japanese source database and a Unicode target Siebel Data Warehouse.

Table 8.  Japanese Code Page to Unicode Settings (Multibyte)

Parameters	Oracle	IBM DB2 UDB
Source DB code page.	JA16SJIS.	943.
Source DB connection code page.	In Workflow Manager > Connections > Relational, set to MS Windows Japanese, super set of shift JIS.	In Workflow Manager > Connections > Relational, set to MS Windows Japanese, super set of shift JIS.
Target DB (Informatica repository and DAC repository) code page.	UTF8 or AL32UTF8.	UCS-2.
Target DB connection code page.	In Workflow Manager > Connections > Relational, set to MS Windows Japanese, superset of Shift-JIS.	In Workflow Manager > Connections > Relational, set to MS Windows Japanese, superset of Shift-JIS.
Informatica Server code page and environment variable settings.	Japanese OS. It is recommended that you explicitly set the NLS_LANG to JAPANESE_JAPAN.JA16SJIS. (For information about determining the NLS_LANG, see Siebel Data Warehouse Unicode and Code Page Procedures.) If the Informatica Server is on UNIX, set PM_CODEPAGENAME to MS932 and set the Informatica Server code page in Workflow Manager to MS Windows Japanese, superset of Shift- JIS.	Japanese OS. It is recommended that you explicitly set the DB2CODEPAGE to 943. If the Informatica Server is on UNIX, set PM_CODEPAGENAME to MS932 and set the Informatica Server code page in Workflow Manager to MS Windows Japanese, superset of Shift- JIS.
Informatica Server (Unicode settings).	Do not set the parameter SIEBELUNICODEDB. Set the Data Movement mode to Unicode.	Do not set the parameter SIEBELUNICODEDB. Set the Data Movement mode to Unicode.
Informatica Repository Server, Informatica client, DAC server, and DAC client code page and environment variable settings.	Japanese OS. Set the NLS_LANG to JAPANESE_JAPAN.AL32UTF. (For information about determining the NLS_LANG, see Siebel Data Warehouse Unicode and Code Page Procedures.) If the Informatica Repository Server is on UNIX, set PM_CODEPAGENAME to MS932.	Japanese OS. Set DBCODEPAGE to 1208. If the Informatica Server is on UNIX, set PM_CODEPAGENAME to MS932.

Bookshelf Home | Contents | Index | Search | PDF