Post reply

Which is faster Truncate and Load or Slowly Changing

  • September 1, 2011 at 1:56 am

    #150470

    Hi I have this problem what among those two choices will i create?

    I know that Truncate and Load will Erase all records from Table and Load All records from source to it.

    (Table to Table)

    And Slowly Changing insert All records if it is new and Update records if it is changed.

    But i don't know exactly which is faster?

    Thanks in Regards

  • September 1, 2011 at 4:18 am

    #1375871

    Posting the same query in two different forums (url]http://www.sqlservercentral.com/Forums/FindPost1168511.aspx[/url]) just a minute apart is unwanted cross-posting and is generaly frowned on.

    Tom

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

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