Dim_Vendor

Ven_PK

VenNum

VenName

Dim_Question

Quest_PK

QuestNum

QuestText

Comment (Y/N)

Category

Dim_Employee

Emp_PK

EmpNum

EMpName

Dim_Date

Dat_PK

Date

Fact_Survey

Ven_FK

Quest_FK

Emp_FK

StartDat_FK

EndDat_FK

Response

ResponeValue

CommentText

Is the structure I am thinking about. I guess my question is how have others modeled survey data in a data warehouse?