Teradata CDC

Database
Highlighted
Enthusiast

Teradata CDC

What could be options in Teradata for Change Data Capture process?

 

The source table and target table are both inside Teradata. The options need to be scalable.

 

There some posts previously. I put two of them here:

 

https://community.teradata.com/t5/Database/CDC/m-p/31482#M13970

https://community.teradata.com/t5/Database/Change-Data-Capture-within-Teradata/td-p/85695

 

I test merge. However the merge will update the row regardless if there is update or not. I use Temporal table to verifiy this ----- all the mutch rows are tried as updated and create addtional new rows.

Even it may have some Teradata internal process to make update more effecitent during merge. However it can't tell which row(s) are really had update.

 

I wonder, is there is better solution within Teradata, not with thrid party tool?

 

If using hash, which hash is safe bet, or hash alway has risk regardless hash method?

 

Thanks