New output instead of an update

Topics: Issues 3: Executing the Component (Run-Time)
Jul 4, 2013 at 6:35 PM
Hello,

We are using the SCD component for a SSIS project and we have some questions about how the source and the dimension are compared in the SCD component.

We have a Description (mark as SCD1) field and we want to implement these behaviors:

New in source:insert in dimension as: [DescriptionInDimension = DescriptionInSource, Active='Y', date_active=sysdate()]
Update of Description in source: update Description in dimension: [DescriptionInDimension = DescriptionInSource]
Delete in source: mark corresponding element in dimension as: [Active='N', date_obsol=sysdate()]

The problem we encounter is that when we delete an element, it works well. When we update an element it works well. When we insert a new element it works well. But when we insert an element X, delete this element X and then reinsert this element X, it does not do an update output but a new output and we have a duplicate of X in the dimension.

We use SCD1 because we don't want to historise the modification on that field.