Which SAEXPDW Generated File Should Be Used for Retail Analytics (RA)? (Doc ID 1378165.1)

Last updated on AUGUST 17, 2016

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

Goal

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?

Solution

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