Post reply

timestamp row if changed using slow changing dimension

  • April 13, 2009 at 1:57 pm

    #208069

    let consider following record

    Table A

    Name Location Date

    Jeff Alabama 04/01/09

    John Alabama 04/01/09

    Table B

    Name Location Date

    Jeff North Carolina 03/01/09

    John Alabama 04/01/09

    Using slowly changing dimension I am able to Update Jeff's location in Table B. However I not sure how to accomplish another task. If the location of a record has changed I also want to timestamp that records with today's date. Can I accomplish that with slowly changing dimension?

    Thanks

  • April 14, 2009 at 1:46 pm

    #977608

    My answer assumes there is a timestamp on that dimension.

    Use a derived column or scripting component (or whatever other source available to you) to create the date field for the SCD. SCD wizard will ask you about input columns. All we have to do is to map your timestamp column against the table's timestamp column.

    Rajib Bahar
    http://www.rajib-bahar.com
    http://www.twitter.com/rajib2k5
    http://www.youtube.com/icsql

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

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