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