Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 08 Aug 2007 @ 22:55:23 GMT

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

Subj:   Re: Fastload + INS / SEL or MultiLoad
From:   Christian Schiefer, makeITdone


normally I prefer to load into an empty table in a staging area. You can use both ( fastload or multiload ) for this action. With multiload you have some better debugging information available ( e.g. recordnumber of record, which did not fit into the layout ).

Your concerns about the final "INS/SEL" step:

1.) 20.000 rows/day is not that much ( I don't know about the size of your installation, but even if it is an SMP single node, I would not expect any performance problem )

2.) I don't know what kind of data you are loading, but if it is a "transaction like" table, it is very likely that you have some date information in the record. If you use PPI and you have the "date" column as part of your (U)PI, then you will not see any performance impact even if the base table is growing and growing. ( I know sites, which are "INS/SEL" about 20.000.000 rows/day into a 8 billion row table (row size about 2000 bytes).... )


Christian from Vienna

  <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: 28 Jun 2020