|
|
Archives of the TeradataForum
Message Posted: Thu, 31 Jul 2003 @ 07:48:21 GMT
Subj: | | Re: ETL process question |
|
From: | | David Wellman |
James,
The last project that I worked on included file headers/trailers mainly for this requirement. Headers and trailers contained a file
identifier and sequence number which was checked against a control table on Teradata prior to the main processing (from memory we used
fastload to populate work tables, then checked the headers against the control table then did the real work). The trailers also contained
date, record count and a hash-total.
Regards,
Dave
| |