Product (Data Source)

Product Data Source contains information/attributes about products which are needed for analysis of products in a Datamart.

In most scenarios, you will copy the data from Product Master into this Data Source, so you also need to keep the fields in sync.

The number of products in this table is usually bigger than the number of records in Product Master because in analysis you keep data about products sold several years back, whereas in Product Master you only need the current products.

Fields

The list of fields in Product Data Source is different in each project, so we will show here the default columns which you can see on a new partition (where it will be in sync with the default Product Master table).

sku – ID of the product.

label – Description of the product.

unitOfMeasure – Unit in which you measure the quantity.

currency – Currency in which you count money.

formulaName – Copy of the formulaName field from Product Master. It does not have any usage in Datamarts.

image – Copy of the image field from Product Master. It does not have any usage in Datamarts.

Since 14.0 - Caribou Lou.

Admin users are not allowed to delete any of the default Data Sources created by the system out of the box. This change is related to the following list of Data Sources.

Name	Label

Name	Label
`Customer`	Customer
`Product`	Product
`cal`	Calendar
`ccy`	Currencies
`uom`	Unit of Measures