Product categories dimension table (s3)
Table for product-category association dimension data, mapping products to their categories.
Column Name | Data Type | Definition | Primary Key | Mapped Dimension Table |
|---|---|---|---|---|
ProductCategoryPK | DECIMAL(19,0) | Surrogate key for the product-category mapping record. | PK | |
ProductId | VARCHAR(36) | GUID of the product. | ||
CategoryId | VARCHAR(36) | GUID of the category the product belongs to. | ||
OrganizationId | VARCHAR(36) | GUID of the organization this record belongs to. | Bi_DimCenter | |
Void | BOOLEAN | Indicates if the record is voided (soft-deleted). | ||
ETLLastUpdatedOn | TIMESTAMP | Timestamp of the last ETL update for this record. | ||
ETLLastUpdatedBy | VARCHAR(50) | User or process that last updated this record via ETL. | ||
Podname | VARCHAR(20) | Name of the source pod from which the data originated. | ||
groupid | BIGINT | Internal to Zenoti. Used for data processing. |