Post reply

using lookup as alternative in SCD type 2 and adding date

  • April 26, 2014 at 12:16 pm

    #306789

    guys please help me..how i can add date using ssis or data tools 2012..My flat files had no date..den my instructor gave us a database where it has recordstartdate, recordenddate and currentdate.how i suppose to add date?

    Can u tell me the steps to how to do it??please response im in urgetn tnx..more questions after this..:-)

  • April 26, 2014 at 12:54 pm

    #1708990

    What do you mean when you say "add date"? you want to add the columns to an SSIS package? to a table? or do you want to add values to a date?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • April 26, 2014 at 1:32 pm

    #1708994

    If you're using a Slowly Changing Dimension, and this is classwork, you might want to read up on them in Kimball's book. He explains how to do this in his book on Data Warehousing (Data Warehouse Toolkit). Definitely worth a read in any case.

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

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