anand_vanam
SSCrazy
Points: 2376
More actions
April 20, 2012 at 4:20 pm
#255224
If source and look up table records has same data except the letters are not in same case ('a', 'A');
Does the SCD Type 2 treats that as a change and creates a new record ?
Koen Verbeeck
SSC Guru
Points: 259015
April 22, 2012 at 11:58 pm
#1477289
I haven't found official documentation for this, but I believe the SCD component is case sensitive.
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
April 23, 2012 at 10:17 am
#1477623
Koen Verbeeck (4/22/2012)I haven't found official documentation for this, but I believe the SCD component is case sensitive.
Koen Verbeeck (4/22/2012)
Thanks Koen
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply