Attributes and measures are sent as different data feeds. Join these feeds together, using the Primary Keys, to derive a flattened view of the data.
To get a flattened view at an item or store grain-level, the following join condition is suggested:
- Join eComm Inventory to Calendar Dimensions on geo_region_cd
- Join eComm Inventory to Product Dimensions on catlg_item_id & op_cmpny_cd
- Join eComm Inventory to DC Dimensions on ship_node_org_cd & geo_region_cd
Note: The Ship Node Organization Code from the eComm table needs to be joined with Distribution Center Number from the DC Dim Feeds table.
As shown:
eComm Inventory Flattened View
©️Walmart | All Rights Reserved | Confidential
