Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2011-10-17 : 08:39:29
|
I WANT TO KNOW ABOUT SSIS SCD TYPE -2 TRANSFORMATIONI NEED HELP ON THIS TRANSFORMATIONANYBODY KNOWS THIS TRNSFORMATION PLS GUIDE ME...mohan |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-17 : 09:07:43
|
SCD type 2 is used for handling dimensions with slowly changing value for historical analysis. this transformation will give you ability to idntify a dimension attribute as type 1 or type 2. Any attribute you identify as Type 1 will have their values updated each time it changes in source so that at any one time you'll have only latest associated value for the attribute in your warehouse. Similarly, if you identify an attrubute as Type 2 it will store historical value ie each change of value will add a new record in your warehouse with valid from and valid to date fields indicating the period during which that value existed. This will enable you to determine what was value of attribute during a particular time period when you're doing historic analysis of the data.ps:- please refrain from using caps in your post as a matter of forum etiquette------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
paultech
Yak Posting Veteran
79 Posts |
|
|
|
|