Which SAEXPDW Generated File Should Be Used for Retail Analytics (RA)?
(Doc ID 1378165.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Retail Merchandising Insights - Version 13.2 and later
Information in this document applies to any platform.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document