|
|
Archives of the TeradataForum
Message Posted: Thu, 28 Aug 2003 @ 09:15:30 GMT
Subj: | | Re: How can I tell when the last time a table was modified? |
|
From: | | Street, John |
Normal processes are to have the ETL/application layer do this either via an update/load timestamp/date column in the table or an Audit
control table that is maintained by the system.
Other than that if you have access logging or query logging enabled on the system look for an entry that is an update / insert / delete
against the table you are wanting to track
Cheers
John
| |