Random thoughts

Hi, SCD (Slowly Changing Dimension) transformation is used to identify the row of source and destination that need to be updated or inserted. In this video session I'm discussing how to use the SCD in your transformation. SCD Type 1 do not care about the history of data it is simply used to updated the destination of data if any changes found in the source of data for existing records. If the records are new in source systems, they will be inserted into destination. It is simple to implement but we lost the history of data. For example customer has changed the mobile no we lost the old one. I hope this session will be useful to you. Please send me your feedback. You can follow me on twitter also: Twitter or send me an email on singh.madhukar@hotmail.com Watch on youtube:   SSIS: Data Transformation Usign SCD Type1 Download here:  Mirror Thanks ~ Madhukar Singh

Hi, Very soon I'm going to start series of video tutorials on Microsoft Business Intelligence Tutorials that includes: SQL Integration Services, Reporting Services, Analysis Services, Performance Point Services and SharePoint Services etc. Please send me your feedback it is important to improve the tutorials. You can tweet also Twitter Thank you much ~ Madhukar Singh