Modifying Staged Data
If you find problems in the data you’ve staged in the RAP database (specific to RI/AIF input interfaces) you have the option
to directly update those tables from APEX, thus allowing you to reprocess the records without uploading new files through
FTS. You have the privileges to insert, delete, or update records in tables where data is staged before being loaded into
the core data model, such as W_RTL_INV_IT_LC_DY_FTS
for inventory data.
Directly updating the staging table data can be useful for quickly debugging load failures and correcting minor issues.
For example, you are attempting to load PRODUCT.csv
for the first time and you discover some required fields
are missing data for some rows. You may directly update the W_PRODUCT_DTS
table to put values in those fields
and rerun the POM job, allowing you to progress with your dataload and find any additional issues before generating a new
file. Similarly, you may have loaded an inventory receipts file, but discovered after staging the file that data was written
to the wrong column (INVRC_QTY
contains the AMT
values and vice versa). You can update the
fields and continue to load it to the target tables to verify it, and then correct your source data from the next run forwards
only.
These privileges extend only to staging tables, such as table names ending in FTS
, DTS
, FS
, or DS
. You cannot modify internal tables holding the final fact or dimension data.
You cannot modify configuration tables as they must be updated from the Control & Tactical Center. The privileges do not
apply to objects in the RDX or PDS database schemas.