Checkpoint in FastLoad

Tools

Checkpoint in FastLoad

Hi all,

I running a fastload which loads the data from a flat file. Size of the file is 25Gb and it consists of 14 billions records.

Can CHECKPOINT value makes a difference to speed up the fastload process. Is there any standard way to specify the number records in CHEKCPOINT like 20% of total records in a file.

Thanks,

Kamlesh Khollam

1 REPLY

Re: Checkpoint in FastLoad

Checkpoints slow FastLoad processing.Set the CHECKPOINT large enough that checkpoints are taken every 10 to 15 minutes.  Usually, this requires a CHECKPOINT value much larger than 100,000.

Refer the below link for more info....

http://forums.teradata.com/forum/tools/usage-of-check-point-in-fastload