Archives of the TeradataForum

Message Posted: Sun, 05 Apr 2015 @ 15:23:30 GMT

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

Hi,

Neither of those options will work for you.

Both INSERT/SELECT and MERGE take table level, write locks of the target table.

If this process has its source data outside of Teradata then you can use TPT. A TPT job can read data from multiple sources and then insert the data into a single table.

Regards,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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