MikeBrey (12/7/2012)
These surveys run for only two weeks twice a year and sometimes for the same vendors. The employee response date they are not too concerned about. Wouldn't you be able to get the question for the Dim_Question.QuestText. I am a bit confused on your snowflake comment.
Well, most surveys I assume have different questions, thus I'd chain from question to survey.
Really, it'd look more like this for how I usually organize that type of data chain (psuedo-design, obviously):
Fact_Answers
EmpID
DateAnswered
QuestID
Response
Comment
Dim_Question
QuestID
SurveyID
QuestionText
ResponseType (Y/N, multipart with list, etc)
Dim_Survey
SurveyID
VendorID
DateStart
DateEnd
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA