All Forums Tools
05 Mar 2012
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.



Kamlesh Khollam

Stefans 38 posts Joined 02/12
05 Mar 2012

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....


You must sign in to leave a comment.