Purpose
To provide the expected size of the source data post-filtering.
Format
| /DATASIZE | number | {RECORDS|BYTES|KILOBYTES|MEGABYTES|GIGABYTES|TERABYTES} |
Arguments
| number | The amount of data released to the task, in the unit specified. |
Location
The option may appear anywhere in the task definition for tasks other than a join. For a join task, the /DATASIZE option for the left side of the join must appear after the source options, for example, /INFILE, that define the left side input stream, and before the source options that define the right-side input stream. The /DATASIZE option for the right side must appear after the source options that define the right-side input stream. Any /DATASIZE option that appears before the first source option for the left side is ignored.
Notes
It is recommended that you provide the /DATASIZE option for a sort or a join task when Connect ETL cannot obtain the information from the file system for the input files. It is also recommended for a Sort task when you request input selection which omits a sizeable percentage of the records.
/DATASIZE overrides any size values you specified for /INFILE.
Examples
/datasize 256 megabytes /datasize 700 records This informs Connect ETL that 700 records of data are released to Connect ETL after input record processing is done