Can any one pls share any doc or case study or if some one can explain the process how to set up the standard archive & Purge main frame jobs in teradata ?
Hi Nishant ,
you may find more information around this on
As per Archive is concerned . It is usually followed to take the Archived data onto Data Tapes and save them in the Library.
However , i was wondering what does it take to move/save/archive the UNUSED Data in to a saperate DB .
This may help historical reporting instantanoues . ex: Could be an "Archive Revenue/Bookings Reeport" based on the Archived Tables .
Archiving data on to tapes sounds age old policy of retaining data . I could be wrong here .
Any Expert comments / insight into Archive would help a lot
Anil Kumar V