Step 1. Verify PowerCenter Repository Database Client and Server Compatibility
Step 1. Verify PowerCenter Repository Database Client and Server Compatibility
The database client and server hosting the PowerCenter repository must be able to communicate without data loss.
The PowerCenter repository resides in an Oracle database. Use NLS_LANG to set the locale (language, territory, and character set) you want the database client and server to use with your login:
NLS_LANG =
LANGUAGE_TERRITORY.CHARACTERSET
By default, Oracle configures NLS_LANG for the U.S. English language, the U.S. territory, and the 7-bit ASCII character set:
NLS_LANG = AMERICAN_AMERICA.US7ASCII
Change the default configuration to write ISO 8859-1 data to the PowerCenter repository using the Oracle WE8ISO8859P1 code page. For example:
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
For more information about verifying and changing the PowerCenter repository database code page, see your database documentation.