Feedback dimension table
Table Name | Column Name | Column Type | Primary Key | Mapped Dimension Table | Mapped Dimension Table Column |
|---|---|---|---|---|---|
Bi_DimFeedback_s3 | FeedbackId | DECIMAL(19,0) | PK | ||
Bi_DimFeedback_s3 | OrganizationId | VARCHAR(36) | |||
Bi_DimFeedback_s3 | GuestFeedback_Ambience | NVARCHAR(4096) | |||
Bi_DimFeedback_s3 | GuestFeedback_Cleanliness | NVARCHAR(4096) | |||
Bi_DimFeedback_s3 | GuestFeedback_Service | NVARCHAR(4096) | |||
Bi_DimFeedback_s3 | GuestFeedback_Therapist | NVARCHAR(4096) | |||
Bi_DimFeedback_s3 | GuestFeedback_Question1 | NVARCHAR(4096) | |||
Bi_DimFeedback_s3 | GuestFeedback_Question2 | NVARCHAR(4096) | |||
Bi_DimFeedback_s3 | GuestFeedback_Question3 | NVARCHAR(4096) | |||
Bi_DimFeedback_s3 | AmbienceCategory | NVARCHAR(4112) | |||
Bi_DimFeedback_s3 | CleanlinessCategory | NVARCHAR(4112) | |||
Bi_DimFeedback_s3 | ServiceCategory | NVARCHAR(4112) | |||
Bi_DimFeedback_s3 | TherapistCategory | NVARCHAR(4112) | |||
Bi_DimFeedback_s3 | RowInsertedDateTime | TIMESTAMP | |||
Bi_DimFeedback_s3 | Void | BOOLEAN | |||
Bi_DimFeedback_s3 | PodName | VARCHAR(20) | |||
Bi_DimFeedback_s3 | EtlLastUpdatedOn | TIMESTAMP | |||
Bi_DimFeedback_s3 | EtlLastUpdatedBy | NVARCHAR(50) | |||
Bi_DimFeedback_s3 | groupid | BIGINT |