Archives of the TeradataForum
Message Posted: Wed, 18 Apr 2001 @ 17:06:11 GMT
| Subj: || || Re: NT Utilities |
| From: || || John Hall |
How much data are your users going to be loading? Are there recoverability issues? Is there an issue about how fast these jobs run (ie-
the job must finish within a couple of hours).
With relatively small volumes of data, you might consider limiting your users to multisession BTEQ .IMPORTs. There is no limit to the
number of jobs that can run concurrently. The limited bandwidth of BTEQ inherently limits the amount of data that is going to be loaded and
minimizes the impact on the database (which is an issue if these jobs are going to run unmonitored).
Admittedly, there's nothing elegant about BTEQ - but it might be the safest thing to put in the hands of your users.