Archives of the TeradataForum
Message Posted: Thu, 09 Aug 2001 @ 15:11:43 GMT
| Subj: || || Re: Fastload vs Multiload |
| From: || || Dara Tressler |
My answer would be a solution to the fact that there is not an automatic method of checking this. The existence of a row in the audit
table for all activities (and making sure that the scripts all update this table appropriately) would allow you to check for the last
activity on a given table. If you note in my last e-mail, there was an entry for Database, Table, Processname. If you change Processname
to be the Process Type (i.e. BTEQ, Multiload, etc.) Then you could detect this. Perhaps a little bit cumbersome but it would work.