Refresh Intervals
The data in the DWH is refreshed at different intervals, depending on the type of data.
Objects like "Warehouses" do not change that often, "PurchaseOrders" are updated much more frequently, but especially Orders and Shipments are very volatile.
Therefore we use different intervals to load new data from Maya into the DWH.
| Interval | Refreshes every |
|---|---|
| A | 60 minutes |
| B | 2 hours |
| C | 24 hours |
The main objects and their refresh intervals are:
| Object | Refresh Interval |
|---|---|
| Countries | C |
| Inbound | B |
| InboundItem | B |
| InboundPackingSlip | B |
| InboundPackingSlipItem | B |
| Orders | A |
| OrderItems | A |
| Product | B |
| PurchaseOrder | B |
| PurchaseOrderItem | B |
| ReturnItem | B |
| Shipment | A |
| ShipmentItem | A |
| Stock | B |
| StockMutation | B |
| StockSummary | B |
| Warehouse | C |
Please note that some of these views are an aggregation of multiple base-layer tables. The Refresh Interval is the max refresh value of the underlying tables.