Data level Audit in Teradata without using Trigger.

General
Enthusiast

Data level Audit in Teradata without using Trigger.

Hi,

I have a requirement like this.

1. I need to capture data level in between changes in a seperate audit table(for all DML operations)

2. I am trying to avoid Trigger in this case.

3. Full row information will not be captured, only old value and new value with date field and corresponding table name with event name.

This is my high level requirement, please suggest me how I can proceed..

Thanks,

Banerjee