Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: GTT-.export
From:   Mohd Suhail

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020