I want to capture all insert , update and delete records from teradata table on daily basis
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.