Oracle^® Business Intelligence Applications Installation and Configuration Guide > Preinstallation and Predeployment Considerations for Oracle BI Applications > Teradata-Specific Database Guidelines for Oracle Business Analytics Warehouse >

General Guidelines for Teradata Deployments

The following requirements apply to Teradata database usage:

• Install the FastLoad and TPump Teradata utilities on the machine on which the Informatica Server is installed.
• When installing Informatica PowerCenter, make sure there are no spaces in the Informatica Server directory name or the directory path. The default directory contains spaces that you must remove manually.
• When you install Oracle BI Applications in a Teradata environment, you must load the pre-built Informatica repository file \dwrep\Oracle_BI_DW_Teradata.rep. For more information, see Process of Loading the Pre-Built Repository Into Informatica.
• In the ODBC configuration for Teradata, set the session Mode to ANSI and DateFormat to AAA, before you create the schema. Tables must be created as case specific. If you do the ODBC configuration after the schema is created, tables might not be created as case specific.
• In DAC ETL preferences update the values of Teradata required hints. Please refer to the DAC ETL preference section.
• The following static parameters are applicable only when the target data warehouse database is Teradata. To avoid overflows if the arithmetic calculation involves any decimal datatype more than 18,3 (precision, scale), add the following static parameters:
  • "as decimal(18,3))" for $$Hint_Tera_Post_Cast
  • "Cast (" for $$Hint_Tera_Pre_Cast