Archives of the TeradataForum
Message Posted: Thu, 29 Nov 2012 @ 10:11:23 GMT
Subj: | | Re: Row Hash Lock |
|
From: | | Frydryszak, Marek |
| How can there be Rowhash blocking when there are no duplicates?" | |
Very easy - rowhash isn't an injective function.
The same phenomena may occur in Tpump, but in Tpump there is a remedy - serialization (DML statements with identical hash values of the rows
are submitted from the same session).
To solve it in Informatica you can use one session ( for small tables) or switch to multiload/fastload protocol.
|