September 11, 2012 at 2:30 am
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,
1,2,3
1,2,3
1,2,3
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
September 12, 2012 at 3:11 am
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 http://dimensionmergescd.codeplex.com/wikipage?title=SCD%20Wizard%20Disadvantages&referringTitle=Home)
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:
http://dimensionmergescd.codeplex.com/
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply