Follow this procedure to define a load plan.
To define a load plan:
1)
In the Tasks pane
of Oracle BI Applications Configuration Manager, select Manage Load Plans,
which appears under the Load Plans Administration heading.
The Manage Load Plans page is displayed.
2)
In the Load Plans
toolbar, click the Add icon.
The Create Load Plan page is displayed.
3)
On the first page
of the Create Load Plan series, specify the following information:
|
Field
|
Description
|
|
Name
|
Enter a unique name for the load
plan.
|
|
Description
|
(Optional) Enter additional
information about the load plan.
|
|
Load Plan Type
|
Select a load plan type. Possible
values are the following:
o Source Extract (SDE) - Includes only those tasks that
extract from the source and loads data into staging tables.
o Source Extract and Load (SDE, SIL and PLP) - Includes all
tasks to extract from the source and load the data warehouse tables.
o Warehouse Load (SIL and PLP) - Includes only those tasks
that extract from the staging tables and load the data warehouse tables.
Note that it may be useful to generate separate
source-specific and data warehouse-specific load plans. By decoupling the
load plans, this allows scheduling a source-specific load plan to run during
hours when most users are not using the source system and scheduling a
separate load of the data warehouse when most users are not using the data
warehouse.
o Domain-only Extract and Load (SDE and SIL) - Includes all
tasks required to extract domain-related records from the source and load the
data into the domain-related tables in the Oracle Business Analytics
Warehouse. Note that domains are used extensively in Oracle BI Applications
Configuration Manager and several properties must be configured before executing
a regular load plan. These properties depend on the domain values found in
the transactional database.
|
|
Source Instances
|
Select the data sources from which
the fact groups will be selected.
|
4)
5)
Click Next.
The second page of the Create Load Plan series is displayed.
6)
In the Available
Fact Groups tab, select the fact groups you want to include in the load plan
definition.
Note that fact groups may belong to a hierarchy of fact
groups. You can select only the top level parent fact group and not a child
fact group.
A load plan must contain at least one fact group, and
multiple fact groups may be selected from one or more data sources.
7)
Click Save. A
submenu is displayed with the following options
o Click Save to save the load plan. After a load plan is
saved, it is displayed in the Load Plans master list.
Click Save and Generate Load Plan to save the
load plan and immediately generate it
No comments:
Post a Comment