I want to capture all insert , update and delete records from teradata table on daily basis

Database

I want to capture all insert , update and delete records from teradata table on daily basis

Hello Everything, 

How can i capture all insert, update and delete records from a given teradata table. Will some permanent journal tables help? i know we cannot read records from journal tables directly. Is there anyway to extract such information from teradata internal tables?

on daily basis, i need to send all transactions happended today on teradata table to downstream applications. Its more like a CDC job.

Appreciate your help on this.

Tags (2)