Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2003 @ 18:47:59 GMT


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


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023