June 2, 2011 at 1:41 pm
Hi Everyone,
I am trying to load a dimension table using SlowlyChangingDimesion transformation.
When i run it for the first time its loading perfectly with out issue.But when i run the same task again its been inserting Around 3500 records again even though there is no change in source.I am using Type 2 Dimension.
Since i am new to Datawarehouse finding difficulty in debuging.
Any help appreciated.
Regards,
Ranjith
June 2, 2011 at 1:50 pm
I would avoid the SCD transform in SSIS personally.
Look at these blogs:
http://sqlblog.com/blogs/michael_coles/archive/2010/11/29/try-n-save-ssis-packages.aspx
and
They give other options to for this,.
June 2, 2011 at 2:16 pm
I *think* (ie i havent checked, so tkae with a grain of salt) that the guys at Pragmatic Works have a 'better' SCD component for SSIS. Could we worth considering. The demo I saw one of their guys give at the sql UG here in Houston showed significant performance improvements. Hsving said that, can't remember if it was his own way of doing SCD or their control/s.
Steve.
June 3, 2011 at 6:56 am
Thanks Gary for the Link.
I have implemented my dimension table change with the way they showed up in
I was able to achieve the goal but i am still facing a problem.
when i did an update to source and run the code again its changing the value of old Record along with adding a New Record to dimension table.This should not be the case only new one should be added with the changes other wise it leads to the violation of Type 2 Principle.
Any Ideas??
Thanks
Ranjith
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply