Same questions different vendors. Would you still recommend the snowflake?

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...

Dim_Vendor

Ven_PK

VenNum

VenName

Dim_Question

Quest_PK

QuestNum

QuestText

Comment (Y/N)

Category

Dim_Employee

Emp_PK

EmpNum

EMpName

Dim_Date

...

Sorry about the delay, other projects and had to research what a temporal fact snapshot table was. If I understand it is a fact table that behaves like a SCD2...

Sorry about the delay but I was able to get SSIS to work and bypass the 32 bit instance. Thank you all for your help.

Thanks for the reply, Jeffrey. I had not had much luck in the past querying directly the ODBC, but I will have another go at it. I will post my...

I tend to agree with you. The problem is that yes, our data source only has a 32 bit driver and linked servers is the only way to connect to...