Refresh Materialized Views (refreshmview.ksh)

Module Name	refreshmview.ksh
Description	Refreshes dept_sales_forecast, class_sales_forecast, subclass_sales_forecast, dept_sales_hist, class_sales_hist subclass_sales_hist, mv_subclass_loc_hist and mv_restart_stock_count materialized views
Functional Area	Financials
Module Type	Ad hoc
Module Technology	ksh
Catalog ID	N/A
Wrapper Script	rmswrap_shell.ksh

Design Overview

This is a batch job that will refresh the specified materialized view. The materialized views that are refreshed are dept_sales_forecast, class_sales_forecast, subclass_sales_forecast, dept_sales_hist, class_sales_hist, subclass_sales_hist, mv_subclass_loc_hist and mv_restart_stock_count.

This program can be run ad hoc and will accept the materialized view name as the parameter. Nested refresh of the materialized view can be controlled using the optional parameter (Valid values: Y - True and N - False). By default, the refresh is nested.

Scheduling Constraints

Schedule Information	Description
Processing Cycle	Ad Hoc
Frequency	As Needed
Scheduling Considerations	It is a Adhoc
Pre-Processing	N/A
Post-Processing	N/A
Threading Scheme	N/A

Restart/Recovery

N/A

Key Tables Affected

Table	Select	Insert	Update	Delete
ITEM_FORECAST	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
STORE	Yes	No	No	No
SUBCLASS_SALES_FORECAST	Yes	No	No	No
CLASS_SALES_FORECAST	Yes	No	No	No
DEPT_SALES_FORECAST	Yes	No	No	No

I/O Specification

N/A