GilaMonster (3/5/2010)
da-zero (3/5/2010)
- never use the build-in slowly changing dimensions wizardIf you make such a statement in an interview, any competent interviewer will immediately follow up with 'Why?'
Well, thanks for interviewing me then 😀
The MS build-in SCD component is for example not that efficient. It uses the OLE DB Command to perform the updates, which means that if a million rows have to be updated, a million different updates will be issued against the DB, instead of one big update. I'm not a DBA, but I think that is not so good for performance, locking and transactions.
The Kimball SCD at Codeplex however has much better efficiency, so this one is prefered above the build-in one.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP