Home Forums SQL Server 2014 Development - SQL Server 2014 Working on type 2 dimension in 2014 visual studio RE: Working on type 2 dimension in 2014 visual studio

  • October 5, 2015 at 12:30 pm

    #1831501

    Below one is the data after SCD 2

    MemberNumberMemberNameActivityStatusEndDateUpdateDate

    1041Community BankInactive2099-12-31 00:00:00.0002015-10-05 12:10:11.000

    1041Discover CreditActive2099-12-31 00:00:00.0002015-10-05 12:10:30.000

    And data expected to be as shown below

    MemberNumberMemberNameActivityStatusEndDateUpdateDate

    1041Community BankInactive2015-10-04 12:10:11.0002015-10-05 12:10:11.000 (Historical Record)

    1041Discover CreditActive2099-12-31 00:00:00.0002015-10-05 12:10:30.000 (New Record)