Archives of the TeradataForum
Message Posted: Sun, 05 Apr 2015 @ 15:23:30 GMT
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.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|