Post reply

Is Slowly changing Dimension task (Type2) CASE Sensitive ?

  • 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 ?

  • 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 question
    My 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.

    Thanks Koen

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply