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.

Dieter