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