Purge Export Data (export_stg_purge.ksh)

Module Name

export_stg_purge.ksh

Description

Purging of all the extracted records (week old) for Xstore.

Functional Area

Foundation

Module Type

Integration

Module Technology

Ksh

Catalog ID

RMS265

Wrapper Script

rmswrap_shell.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This batch job will be used to remove records that are a week old from the following staging tables.

  • Merchandise Hierarchy Export Staging

  • Organizational Hierarchy Export Staging

  • Store Export Staging

  • Differentiator Export Staging

  • Differentiator Group Export Staging

  • Item Export Staging

  • VAT Export Staging

  • Related Item Export Staging

  • Data Export History

Batch will purge all the records (Week old records) from its respective staging table whether data get extracted or not.

Restart/Recovery

N/A

Design Assumptions

N/A