Miscellaneous Information About Oracle BI Applications Deployments
3-38
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
3.9.5 Running an ETL with a Non-English OLTP Data Source
To run an ETL with a non-English OLTP data source, you must make a copy of an
appropriate source system container, and configure the language, country, and
continent parameters.
To run an ETL with a non-English OLTP data source
1.
In DAC, select File, then New Source System to display the New Source System
Container dialog box.
2.
Select the Create as a Copy of Existing Container radio button.
3.
From the Existing Containers drop-down list, select the container that you want to
copy, then click OK.
4.
Go to the Design view.
5.
Ensure that you have selected the correct container from the Containers
drop-down list.
6.
Select the Source System Parameters tab.
7.
Use the Edit tab below the list of Source System Parameters to change the value of
the following parameters in the list:
$$DFLT_LANG (Default Language) For example, for a Japanese data source,
change this value to JPN.
(optional) $$DFLT_COUNTRY (Default Country)
(optional) $$DFLT_CONTINENT (Default Continent)
Tip
: To find out the value to specify for the $$DFLT_LANG parameter, issue the
query 'select VAL from S_SYS_PREF where SYS_PREF_CD=<ETL value>' against
the OLTP database. For example, to find out the default ETL language, issue the
following command:
select VAL from S_SYS_PREF where SYS_PREF_CD='ETL Default
Language';
8.
Create a new ETL plan for the new source system container, and edit its
parameters, as follows:
a.
Click the Execute tab.
b.
Click the Execution Plans subtab.
c.
Click New to create a new blank execution tab and use the subtabs below (for
example, Subject Areas, Parameters, Ordered Tasks) to specify the execution
plan details.
d.
Click Save.
9.
Click Run Now to run the new ETL plan (or use the Schedule tab to specify when
you want to run the new execution plan).