Post reply

Incremental & Full Load plan?

  • March 16, 2009 at 12:29 pm

    #207493

    Technology:

    SSIS 2008

    SQL Server 2008

    Oracle

    I need a good plan to stick together incremental load (Extract,Transform,Load) and full load. I have the incremental load working for now. I working on the full load at the moment. There are 35 tables and all of them have many fields and over 50 Million records. I was planning to load 3 tables per day. What are the things I have to be careful about? What could go wrong? Any better plan?

  • March 16, 2009 at 7:18 pm

    #960726

    pleasehelpme (3/16/2009)

    Technology:

    ... Any better plan?

    Backup/Restore? What exactly do you mean by "full load"?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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