Archives of the TeradataForum
Message Posted: Sun, 14 Jun 2009 @ 09:16:05 GMT
Is it just for this one interface that you have problem?
Is it during specific time of the day you have problem with this interface (If no, then I would check the Informatica Mapping).
And yes, there will be write locks and it creates Log, error tables in a specific database as specified in your script (exclusive locks in this case).
I have seen dictionary contention for mostly poorly written TPUMP jobs.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|