vii
4.18.4.1
Updating Siebel Transactional Database Schema Definitions ............................ 4-89
4.18.4.1.1
How to Run the DDLIMP Tool From The Command Line ......................... 4-90
4.18.4.1.2
How to Apply Siebel CRM Schema Changes For Oracle, DB2/UDB,
MSSQL ................................................................................................................. 4-90
4.18.4.1.3
How to Apply Siebel CRM Schema Changes for DB2 on OS/390 and
z/OS ..................................................................................................................... 4-91
4.18.4.1.4
How to Apply the Siebel CRM Image Table to a Siebel Transactional
Database............................................................................................................... 4-92
4.18.4.1.5
About Delete Triggers ....................................................................................... 4-93
4.18.4.1.6
How to Verify Siebel (CRM) Schema Changes .............................................. 4-93
4.18.5
Teradata-Specific Configuration Tasks ......................................................................... 4-93
4.18.5.1
Setting Up the Code Page File Property for Unicode Environments on Teradata
Databases ................................................................................................................... 4-94
4.18.5.2
Setting Up the HOSTS File for Teradata Installations on Windows .................. 4-94
4.18.5.3
Setting Up the HOSTS File for Teradata Installations on UNIX......................... 4-94
4.18.5.4
Teradata-Specific Installation Checklist ................................................................. 4-95
4.19
About Running A Full Load ETL .......................................................................................... 4-95
4.19.1
An Example of Running a Full Load ETL ..................................................................... 4-96
Part III
Appendices
A
Supporting Tasks for DAC and Informatica PowerCenter
A.1
How to Log into DAC ............................................................................................................... A-1
A.2
About DAC User Account Management................................................................................ A-2
A.2.1
Creating, Deleting and Inactivating User Accounts ...................................................... A-3
A.3
How to Set DAC System Properties........................................................................................ A-4
A.4
How to Start and Stop the DAC Server .................................................................................. A-6
A.5
Enabling DAC Client Communication with Informatica PowerCenter ............................ A-7
A.5.1
How to Define the Informatica Domains File Path in the DAC Client Environment
Variables.............................................................................................................................. A-8
A.5.2
How to Verify the DAC Client Is Able to Use pmrep and pmcmd............................. A-8
A.6
Enabling DAC Server Communication with Informatica PowerCenter ........................... A-9
A.6.1
How to Set Environment Variables for DAC Server Communication on Windows A-9
A.6.2
How to Set Environment Variables for DAC Server Communication on UNIX .... A-10
A.6.3
How to Verify Java JDK Availability and Version ...................................................... A-11
A.7
About the DAC Server Shell Scripts...................................................................................... A-11
A.8
How to Log Into Informatica Administrator ....................................................................... A-13
B
Localizing Oracle Business Intelligence Deployments
B.1
Process of Maintaining Translation Tables for Oracle BI..................................................... B-1
B.1.1
Upgrading Oracle Business Intelligence Seed Data for Non-English Locales........... B-2
B.1.1.1
Importing Locale Seed Data Into The Translation Table (W_LOCALIZED
_STRING_G)................................................................................................................. B-2
B.1.2
Externalizing Customer Metadata Strings ...................................................................... B-3
B.1.3
Adding Custom Translations to the W_LOCALIZED_STRING_G Table ................. B-4
B.1.3.1
Adding String Translations for Analytics Metadata .............................................. B-4
B.2
About Translating Presentation Services Strings .................................................................. B-5