1 million plus records

  • This should have been added to the Anatomy of an Incremental Load topic.

    As is always the case, you never deal with just a 100 thousand records, in reality it's more like over a million.

    So I would like to know what do you think about using drop table followed by select into, finally rebuild the indexes/views which is a technique I used in a package where I loaded many tables with 4-10 million records. At the same time the source table schema was different to the destination table's schema, just to make life interesting. 🙂

    Thanks for your comments.

Viewing 0 posts

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