Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 20 Apr 2004 @ 21:36:45 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Keeping source in sync with the warehouse
From:   Victor Sokovin

  The reference to DataStage is really grasping because I don't know the solutino. If that is not the direction I need to go, alternate solutions are welcome. Thanks.  

I had only a brief encounter with DS a few years ago so I don't know which auditing features it offers now. Perhaps somebody else can advise.

If you want to keep an eye on the ad hoc changes in the source Oracle system there are dedicated methods within Oracle such as triggers, auditing and LogMiner. The latter is no adverse performance impact and is quite cheap to implement. I don't know whether you have looked into such options and what you think about them.

There is also a more discrete approach with periodic snapshots and deltas between them. A lot of work and some changes might remain unnoticed.


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