Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Issue with slowly changing dimension component Expand / Collapse
Posted Tuesday, September 11, 2012 2:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:26 AM
Points: 1, Visits: 51
Hi all,

First time i am trying with SCD component. Just a hands on practice to know about the component.

I have a source table with 3 records, below are the list of records i have in the table,


when i applied the SCD to transfer the records to destination table, Type 1 and the business key is column1.

i am getting the following behaviour for the 2 continous execution,

First Run - inserting 3 records irrespective of validationg the repetation of column values.
second run - No change. I understand this, as there was no change in the records so no change in the table.

But for the first run i do not understand why its inserting all 3 records. As per my understanding, it should insert only one record.

Also i tried inserting one record manually(1,2,3) to the table and tried running the package, there was no change in the table. i understand this aswell, as there was no change in the records coming in.

Kindly clarify why for the first run alone, its inserting records without validating the repetation of records.

Thanks & Regards,
Dhivya S
Post #1357191
Posted Wednesday, September 12, 2012 3:11 AM



Group: General Forum Members
Last Login: Yesterday @ 5:40 PM
Points: 187, Visits: 748
Is it because of this:

No explanation is given for why certain rows get sent to certain outputs in order to debug data. Items shown as “new” or “changed” may be so due to trailing spaces, case, collation, implicit data type conversion issues on any one of the keys or attributes – but none of that is fed back to you.

(this is from

I have not used the SCD component before, I have only ever used stored procedures to perform the task. All my research on the topic indicates that the packaged component is not much use for real world scenarios, and that this one is better:

So if it's important to learn about the out of the box components, by all means continue, but if you wish to use a more 'real world' component, then use the one at the link above.
Post #1357848
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse