Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: What is a Change data capture (CDC) concept
 
From:   Bodla, Sravan Kumar

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020