Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 17:22:58 GMT

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

Subj:   Re: Capturing Updates in a Readable File
From:   Anomy Anom

<-- Anonymously Posted: Thursday, March 25, 2004 10:50 -->


It took a while for me to test the case before saying to you why not possible. What I did was I archived the (after) journal, applied that to an identical empty table. The test contained just 1 insert, 1 update and 1 delete transaction. The insert/update rows were created in the empty table successfully. However No rows for the deleted row (obviously funny). The Roll forward doesn't generate error for the missing delete rows. So unless you have some mechanism to track the deletes you will not be able to apply that to your Non-Teradata database. of-course if you had the row in the log-table to begin with the roll forward would delete it (I tested that scenario as well). Please ask if you want the test examples.


  <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