Which SAEXPDW Generated File Should Be Used for Retail Analytics (RA)?
Last updated on JANUARY 18, 2018
Applies to:Oracle Retail Merchandising Analytics - Version 13.2 and later
Information in this document applies to any platform.
Checked for relevance at 12-7-2013
Checked for relevance at 22-12-2014
This document discusses which SAEXPDW generated file should be used for Retail Analytics (RA), as the script produces multiple files with varying structures.
After completing the following steps:
1. Execute Retail Sales Audit (ReSA)
2. Run SAEXPDW and RESA2DW for each file
3. Observe XTERN_RDWT table on RMSRA schema
We note that SAEXPDW script generates these four files:
RDWT - Transaction file
RDWF - Form of Payment (Tender) file
RDWS - Store Totals Output file
RDWC - Cashier Output file
RESA2DW processes each file and prepares them for export to RA, however the prepared file structure is totally different for all files.
Which SAEXPDW generated file should be used for RA?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms