My Oracle Support Banner

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

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

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

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
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.