To configure data warehousing jobs on Oracle CMSs, run commands using a utility such as Oracle SQL Plus to change job parameters to new values.
Run this command:
begin dlp_agg. rut_dlp_set_aggregation_values (<parameter>[,<parameter>]); commit; end;
Where <parameter> defines the new value for an aggregation parameter.
Each query can include multiple parameter definitions, separated by commas.
If a parameter is not explicitly specified, it retains its current value. The exception is the Truncate_On_Next_Run parameter, which is implicitly set if you change the No_Older_Than_Date parameter. That is, if you change the maximum age of events in the data warehouse, all existing event data gets purged before the job added new event data into the data warehouse.
Available parameters are described in the following sections.
The following example resets the oldest event timestamp to 4 July and the maximum event age to 6 months:
begin dlp_agg.
rut_dlp_set_aggregation_values
(No_Older_Than_Date=>to_date('20110401 06:00:00','YYYYMMDD HH24:MI:SS'),
Fact_Expiry_Age_Months=6);
commit; end;
|
Copyright © 2012 CA.
All rights reserved.
|
|