Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 20:24:23 GMT

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

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

<-- Anonymously Posted: Thursday, March 25, 2004 15:21 -->

I'm the Original Poster.

I don't know how BEFORE journal would help. Can I have two JOURNAL tables defined on my tables and if so, can I specify that BEFORE goes to one table and AFTER goes to the other?

We do apply our journals to another copy of our tables on another machine. Since we apply them every hour, they run fairly quickly - 1 or 2 minutes.

A solution we have been looking at is to compare today's export with yesterday's export and only send the differences to the Oracle app. But that requires 2 copies of the data and I a lot of tapes.

  <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: 27 Dec 2016