Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 29 Mar 2004 @ 20:24:17 GMT

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

Subj:   Re: Teradata Peformance issues when loading data to Teradata using ETL tools like Informatica or Data Stage
From:   Dieter Noeth

Victor Sokovin wrote:

  Minor correction: In restarts it must do the select again--the queryresults do not persist across sessions or restarts.  

  Unless you use checkpoints. I have here the FastExport Reference Release 07.06.01 (June 2002) in which the checkpoints are described on page 2-48.  

But this is not the same as ML/FL checkpoints, it's splitting a query manually. The last select still must be done again.

  In addition to ML, checkpoints should now be readily available in the latest releases of FastLoad and FastExport. On earlier releases people had to do additional programming to use them.  

There have been checkpoints in FastLoad for years specifying a number of rows.


  <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