Introduction

The product dimension is intended for those fact tables and star schemas that need to capture performance measurements related to products.

Description

The facility dimension is derived from:

  1. Product entity


and consists of following elements (fields):

namealiastypedescription
dimensionId
id-longthe unique identifier of the record
productId
idthe natural (primary) key from table 1 (see above): productId
internalNameproductNamedescription

The name of the product. 

sku
descriptionThe StockKeepingUnit of the product.





Related tickets