Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 13 Nov 2002 @ 18:13:41 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: ETL approach
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, November 13, 2002 13:07 -->

The main reason in my view as to why the 4-step process is preferable to the Insert-select is that - If the Insert-select abends in the inserting stage, it starts a expensive rollback consuming a lot of machine resources and also locks up the table being inserted into. Clearly this is not acceptable with the increasing expectation of DW being up 24 x 7.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020