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

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

Table 9. Japanese Code Page to Code Page 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.	JA16SJIS.	943.
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, Informatica Repository Server, Informatica client, DAC server, DAC client 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.