Archives of the TeradataForum
Message Posted: Wed, 01 Aug 2012 @ 12:19:19 GMT
CDC is used when you want to bring back your tables to last loaded date(last updated/modified date). (will be useful when your tables are corrupted or loaded wrongly).
You need to have a CDC table for loading CDC details. (tablenames, last updated timestamp, no. of rows loaded etc...)
UPDATE ABC_DB.CDC_Details_TABLES SET LAST_UPDATE_DATE= ('25-Jul-2012 23:59:59','dd-mon-yyyy hh24:mi:ss') WHERE TABLE_NAME='GL_abc_xyz';
Once, your table is brought to its old state, you can again start loading data till the date required.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|