EDW enterprise data warehouse

RPM Retail price management

REiM Retail Invoice Match

ReSA Retail Sales Audit

A View table is appended with V suffix at the end

The extract process takes multiple types of db –> converts them to flatfiles –> flat files match the staging schema –> so they can be further processed as per required.

Load job: From flat files to staging table –> process it( transformation and lookup) –> move to target table

Tables failed from load –> Reject Table with necessary logs