DW Incremental Load

  • In my envrionment not all the tables have datetime field that

    indicates when the row is created or updated. Coming up a DW project

    that will be implemented I would like to ask the community what kind

    of techniques they use for Incremental data loading with SSIS. There are some

    tables that has over 20 million rows that I don't want to do full load.

  • There are quite a few articles in the Articles section dealing with just that... Among which:

    Anatomy of an incremental Load[/url]

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

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

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