Archives of the TeradataForum

Message Posted: Wed, 01 Aug 2012 @ 12:19:19 GMT

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

Hi,

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.

Thanks,

Sravan.

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