Oracle Retail Knowledge Base

How to seed all staging tables using MFCS integration

2 min read

Context

Runbook to seed all dimension staging tables in AIF DATA from MFCS. Enabling and running the RDE_DIM_FLOW_ADHOC process extracts every dimension and facts from MFCS into its *_DS staging table in the RADM01 schema. Run it during initial setup, after the calendar is loaded and the business date is set.

Load the calendar dimension first

The calendar dimension must be loaded first, as an initialization of the system, before seeding all dimensions here. To load only the calendar dimension, use Calendar initialization using MFCS integration, which runs a subset of the same process.

Seed the dimension staging tables via POM

  1. Accessing POM click on the top left menu
  2. Select the sub menu “Tasks” and then “Batch Administration”
  3. Select the “AIF DATA” scheduler and then the “Standalone” chain
  4. Look for the RDE_DIM_FLOW_ADHOC process, click on “Actions” and enable all jobs
  5. Click “ok” to confirm the action
  6. Click on the top left menu
  7. Select the sub menu “Tasks” and then “Batch monitoring”
  8. Select the AIF DATA scheduler, and restart the schedule to apply the changes
  9. After POM reload, select the AIF DATA scheduler on the Standalone chain
  10. Find the RDE_DIM_FLOW_ADHOC process, verify the active jobs are correct, and press the start button.

After the run completes, check in AIF APEX that all *_DS staging tables are populated:

SELECT /*+ PARALLEL(8) */ t.table_name,
       CASE
           WHEN o.table_name IS NOT NULL THEN
               TO_NUMBER(
                   EXTRACTVALUE(
                       XMLTYPE(
                           DBMS_XMLGEN.GETXML('SELECT COUNT(*) AS c FROM RADM01.' || t.table_name)
                       ),
                       '/ROWSET/ROW/C'
                   )
               )
           ELSE NULL
       END AS row_count
FROM (
    SELECT table_name
    FROM c_ri_subjectarea
    WHERE schema_name = 'RADM01'
    AND table_name like '%DS'
) t
LEFT JOIN all_tables o
       ON o.owner = 'RADM01'
      AND o.table_name = t.table_name
ORDER BY row_count DESC NULLS LAST;

If a staging table did not populate, check its source tables in MFCS via RDE Input interfaces.

Graph View

Backlinks