Archives of the TeradataForum

Message Posted: Mon, 27 Jul 2009 @ 07:05:05 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello Rahul,

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 " will cause a row hash lock.

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>