Archives of the TeradataForum
Message Posted: Wed, 19 Mar 2008 @ 13:40:22 GMT
How busy is your W'hse the rest of the week?
Have U considered moving some of the archives to a different window?
Monday from 4-6am? Friday at cob? What about daily for one hour at cob? Implementing any of these alternatives shortens the big window -- perhaps by as much as 3 - 6 hrs.
Some of the smaller ones could even run during the work day.
As suggested by Idrike, grouping jobs to isolate the problem data structures from their respective load and archive processing is a good idea. U may end up keeping an eye on the schedules to ensure that schedule changes don't blindside your arrangements.
How critical is the loading that occurs during the BAR window? If this ELT/ETL activity is critical to the business, then approach the budget gods (in these recessionary times) and obtain funding to enhance the archive capability.
In the end, U'll judge the trade-offs and take your best shot.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|