Archives of the TeradataForum

Message Posted: Thu, 29 Nov 2007 @ 17:08:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thu, 29 Nov 2007 11:03 -->

John,

Yes, that is impossible due to the way our process works. The population of the WRK tables are based upon steps above it like updates to target tables. Then updates to target tables follow the WRK inserts as well. These are all wrapped in an BT ET for rollback and restart purposes.

Seem like the statements inside the BT ET could be committed individually (as if they were not in a BT ET) , to allow the stats to be collected, but then the Transient journals would still be kept around (for the entire BT ET) in case of a failure, then the entire thing could roll back anyway. This would allow the stats to run within the BT ET. Seems like this would be a very common problem for many Data Warehouses processing jobs.

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>