Data Protction (Near Real DR setup) Triggers and Shadow Tables
HI ALL ,
We are plaining to impliment near real time DR setup , we have two teradata system . Production 6 Node and DR 2 node. Here is what I am thinking :-
Create a trigger , when ever any tables get "INSERT,UPDATE OR DELETE " Operation on it , trigger should be generated and it should create SHADOW tables for the same tables , which has only "INSERT,UPDATE OR DELETE " data in it , which can be easly FEXP or FLOAD to DR system.
Can any one has any idea about it , or implited any such solution to create near real time DR , If any one has any idea , please shear here , will be great help.