DSXchange

Hi,
I have a job which fails regularly on weekend, but its running fine over weekdays.

ODBC => Transformer => TD Mload

We have two target table stage on Output. Though there are no rows to fetch Job is running for 25 min & fails with above error.

Please help if we need to set some parameter at admin level or at Database.

Thanks,
Bhaskar

So... it runs ok when there are records to load but doesn't when there aren't? Worst case you could split the job - land the data and only issue the MLoad if there's date to load.

Or you could just wait for someone who actually knows something about Teradata to respond.