The Scintilla BI Link pre-joined SSI table delivers week-level aggregated data across nine source tables—Backroom Adjusted Inventory, Inventory Adjustments, MTR, MUMD, Store Customer Returns, Store Fulfillment (OPD), Store Inventory, Store Returns, and Store Sales—in a single pre-compiled dataset. Because the data is aggregated at the week grain, users should carefully review aggregations and calculations to ensure analytical accuracy.
The following provides SSI table details.
| Specification | Details |
|---|---|
| Table Type | Fact Table |
| Refresh Frequency | Daily |
| Target Refresh Time | Monday - Friday: 3:00 PM CST. Saturday, and Sunday: 11:30 PM CST |
| Data Grain | catlg_item_id rpt_cd store_nbr wm_item_nbr wm_yr_wk_nbr |
| Table Name | wmt-dv-bi-link-prod.dv_psp.ssi |
©️Walmart | All Rights Reserved | Confidential