Archives of the TeradataForum
Message Posted: Mon, 27 Jul 2009 @ 07:05:05 GMT
Simultaneous inserts is possible only in the case of row hash locks. An "Insert ...Values" statement will cause a row hash lock but an "insert...select statement" will cause a table lock.
Also an "insert....select where
You may consider using a 'multi statement' request as well.
The suggestions made in the previous post is correct. Why not export directly to a flat file instead of using GTT? Also, I would like to know how informatica will insert rows in the teradata table using the exported files.
Does it create 'Insert...values()..." statements in the back end for every record in the exported file? If it does, then using this approach will increase the performance.
However, if this does not happen, then as the previous posts suggest, some utility like mload may be used. In this case, table locking will apply and simultaneous inserts will not be possible.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|