About Running A Full Load ETL
Installing and Setting Up Oracle BI Applications
4-95
<IP address of remote server> <remote server> <remote server>COP<n>
For example:
172.20.176.208 tdatsvr tdatsvrCOP1
Where tdatsvrCOP1 is the alias for the remote server. The alias must begin with an
alphabetic string and end with the COP<n> suffix, where <n> is a number
between 1 and the total number of applications processors that are associated with
the Teradata communications processor.
3.
Save the HOSTS file.
For more information about setting the TDPID parameter, refer to the Teradata
documentation.
4.18.5.4 Teradata-Specific Installation Checklist
Table 49
provides a list of Teradata-specific installation and configuration steps that
are performed during the Oracle BI Applications installation and configuration
process. You should review this list to make sure that you have performed all of the
required Teradata-specific steps.
4.19 About Running A Full Load ETL
After you have installed and configured Oracle BI Applications, your Oracle Business
Analytics Warehouse (OLAP) database is empty. You need to perform a full load ETL
to populate your Oracle Business Analytics Warehouse.
Table 49
Teradata-Specific Installation Checklist for Windows
Action
Link to Topic
Review Teradata-specific
database guidelines.
Section 3.5, "Teradata-Specific Database Guidelines for Oracle
Business Analytics Warehouse"
.
Create or drop data
warehouse tables.
Section 4.9.2, "Creating Data Warehouse Tables on a Teradata
Database"
Create or restore the
Informatica Repository
using the Informatica
Repository Manager. You
cannot create or restore the
Informatica Repository
using DAC. You must use
Informatica Administrator.
Section 4.6.5, "Restoring the Pre-built Informatica Repository"
Configure the source and
data warehouse database
relational connections in
Informatica PowerCenter
Workflow Manager. You
cannot use the DAC's Data
Warehouse Configurator to
configure relational
connections.
Section 3.5, "Teradata-Specific Database Guidelines for Oracle
Business Analytics Warehouse"
Set the Code Page File
Property for Unicode
Environments.
Section 4.18.5.1, "Setting Up the Code Page File Property for
Unicode Environments on Teradata Databases"
Set up the HOSTS file.
Section 4.18.5.2, "Setting Up the HOSTS File for Teradata
Installations on Windows"