Item dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|
bi_dimitems_s3 | ItemId | VARCHAR(36) | PK | ||
bi_dimitems_s3 | ItemName | NVARCHAR(512) | |||
bi_dimitems_s3 | ItemCode | NVARCHAR(512) | |||
bi_dimitems_s3 | BusinessUnitId | NVARCHAR(MAX) | |||
bi_dimitems_s3 | BusinessUnitName | NVARCHAR(MAX) | |||
bi_dimitems_s3 | TAGS | VARCHAR(MAX) | |||
bi_dimitems_s3 | OrganizationId | VARCHAR(36) | |||
bi_dimitems_s3 | void | BOOLEAN | |||
bi_dimitems_s3 | EtlLastUpdatedOn | TIMESTAMP | |||
bi_dimitems_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |||
bi_dimitems_s3 | PodName | VARCHAR(20) | |||
bi_dimitems_s3 | groupid | BIGINT |