tag:blogger.com,1999:blog-3689647052791307812.post1395591143533219183..comments2024-01-27T22:41:04.808+11:00Comments on Richard Lees on BI: SSIS Slowly Changing Dimension SCD Wizard is Too SlowRichard Leeshttp://www.blogger.com/profile/05671716466559973540noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3689647052791307812.post-3113995880676741992010-04-16T15:31:58.443+10:002010-04-16T15:31:58.443+10:00Hi Richard,
It is a great post and very useful fo...Hi Richard,<br /><br />It is a great post and very useful for me. We are using MERGE statement for SCD1 and SCD2 dimensions.<br /><br />Thanks<br />pravpravhttps://www.blogger.com/profile/06843481927003963634noreply@blogger.comtag:blogger.com,1999:blog-3689647052791307812.post-21936577189133403992010-02-16T07:05:16.254+11:002010-02-16T07:05:16.254+11:00Kimballs SCD component is quite well known. I hav...Kimballs SCD component is quite well known. I haven't tested it. Of course it is faster than the SCD wizard, but it couldn't be faster writing your own queries. However, if you had a lot of SCDs, it might make your packages simpler.Richard Leeshttps://www.blogger.com/profile/05671716466559973540noreply@blogger.comtag:blogger.com,1999:blog-3689647052791307812.post-17607610838673323842010-02-16T02:41:51.703+11:002010-02-16T02:41:51.703+11:00Richard,
I'm curious if you have tried the Ki...Richard,<br /><br />I'm curious if you have tried the Kimball SCD component: http://kimballscd.codeplex.com/<br /><br />I have found that it performs significantly better than the SCD component that comes with SSIS 2008. It's still not as fast as straight SQL can be, but deninitely much better.<br /><br />Regards,<br />DrewDrewhttps://www.blogger.com/profile/04609335440143478573noreply@blogger.com