Archives of the TeradataForum
Message Posted: Fri, 12 Dec 2003 @ 16:12:35 GMT
We have a month end process where 30 countries send us their "numbers" for the month, but can re-post the data any number of times over the course of a week. We currently load all 30 countries into the same end table. The end table has a Primary Index of Customer_Nbr and Material_Nbr. Each country sends its data in by month and country_cd - so they delete from the final table for the current month and their own country cd then re-insert the data.
The problem is that if multiple countries come in at the same time, they have to wait in line because Teradata is performing a table lock on the table.
We've tried a row hash lock, but the loads were still single streamed.
Seems odd that each country can't delete and load its own data (no overlap) on the same table concurrently, but there doesn't seem to be a way around this in Teradata.
Any ideas, or is the only way to get a concurrent load going to load each country to its own table.
Hope this makes sense.
Thanks in advance!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|