 |
 |
Archives of the TeradataForum
Message Posted: Fri, 12 Dec 2003 @ 18:47:59 GMT
| Subj: | | Re: Concurrent Loads/Deletes for Staging Table |
| |
| From: | | Victor Sokovin |
Duane,
| | Any ideas, or is the only way to get a concurrent load going to load each country to its own table. | |
It is certainly not the only way but it is the one to consider. A lot depends on data volumes and the hardware so your mileage may vary
but I would try to load each country month end numbers to a separate *temporary* table temp_table_country_cd (perhaps using your current
method), with the subsequent 'delete from end_table' and 'insert into end_table select * from temp_table_country_cd'.
I understand you don't have the country_cd in your PI - do you use another reference table with (country_cd, Customer_Nbr)?. If you can
afford adding country_cd to the end_table, it might speed up this type of queries, especially the deletes, but doing the deletes via the
ref. tables is still a possibility. Again, this may or may not work for you but I would not reject this simple method without giving it a
try. It would allow you to keep the same end_table (plus perhaps the country_cd in the PI) and be more flexible with parallel (re)loads.
I had a chance to work on two international projects in the past, one with 10 countries and another with 19, so I could not resist to add
my two cents :-)
Regards,
Victor
| |
