Category Products Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Bridge/association dimension table linking products to their assigned categories within an organization.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| productcategorywid | BIGINT IDENTITY | No | Surrogate warehouse identifier (auto-generated) |
| ProductCategoryPK | DECIMAL(19,0) | Yes | Source system primary key for the product-category association |
| ProductId | VARCHAR(36) | Yes | Unique identifier of the product |
| CategoryId | VARCHAR(36) | Yes | Unique identifier of the category |
| Void | BOOLEAN | Yes | Soft-delete flag |
Note: All dimension tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlLastUpdatedOn,etlLastUpdatedBy) which are omitted from this reference for brevity.
Primary Key
productcategorywid
Foreign Keys
| Column | References |
|---|---|
| ProductId | the product dimension (Bi_DimProduct or equivalent) |
| CategoryId | the category dimension |
Was this article helpful?
Your feedback helps us improve our documentation.