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.
Found an issue in documentation? Write to us.