Archives of the TeradataForum
Message Posted: Mon, 29 Mar 2004 @ 20:24:17 GMT
| 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
| ||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.