Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 04 Jan 2008 @ 21:20:53 GMT

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

Subj:   Re: Updating target table row multiple times
From:   Kamin Shah

My suggestion (not the fastest one) was to update the target table multiple times until all rows have bene accounted for. So if you sort the staging table by timestamp and pick up the min into a work table and then use that to update the base tables and mark the updated rows as processed in the stage table. Delete the work table.

Next time around only looking at records which are not processed and repeat the above step.

Kamin Shah
Systems Engineer
ViPS, Inc.

  <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: 23 Jun 2019