Attributes and measures are sent as different tables. You can join these tables together, using the Primary Keys, to derive a flattened view of the data.
To get a flattened view of Store Sales, the following join condition is suggested:
- Join Store Sales table with the Store Dimensions table on store_nbr
- Join Store Sales with Item Dimensions on wm_item_nbr
As shown:
Store Sales Flattened View
©️Walmart | All Rights Reserved | Confidential
