June 24, 2009 at 3:25 am
I'm using an SCD in SSIS to perform an upsert from a source table to a dimension table. This is my first experience with SCD's and I just want to know how do I delete rows from my dimension table that no longer exist in the source table during the upsert operation?
June 29, 2009 at 4:37 am
Has anybody any thoughts on this at all?
I find it very surprising that 1) SCD does not cover records that have been deleted at the source and 2)there does not seem to be much discussion on the topic on the net. Surely this is a common requirement?
June 30, 2009 at 5:04 am
Hi,
I have also gone thru this situation. I have to explicitly expire the rows by running an update query, that no longer exists in the source table.
If any body has better alternative, then we can implement that. Thanks.
June 30, 2009 at 8:52 am
You can use the Kimball Method SSIS Slowly Changing Dimension Component[/url]. This component supplies six outputs: Unchanged, New, Expired SCD2, Updated SCD1, Auditing, and Invalid Input and is much faster than the standard SCD SSIS component.
Yann Nguyen France
MCITP: Business Intelligence Developer 2008
June 30, 2009 at 9:47 am
That looks like it would fit the bill perfectly. I'll be checking it out later on.
Thank you yann_nguyen 😀
July 1, 2009 at 6:21 am
hey thanks for the new SSIS component!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply