# eComm Inventory Flat View

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:

1. Join *eComm Inventory* to *Calendar Dimensions* on **geo\_region\_cd**
2. Join *eComm Inventory* to *Product Dimensions* on **catlg\_item\_id** & **op\_cmpny\_cd**
3. 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:

[block:image]
{
  "images": [
    {
      "image": [
        "https://files.readme.io/b5c8314af3348557a9a1767d423368bf42326d6e017f56be4d8a4312634c695f-eComm_Inventory_Flattened_View.svg",
        "eComm Inventory",
        "Alt text"
      ],
      "align": "center",
      "caption": "eComm Inventory Flattened View"
    }
  ]
}
[/block]

<br />

<br />

©️Walmart | All Rights Reserved | Confidential