What does the Output Data Tool's 'Max Records Per File' option do?

The 'Max Records Per File' option in the Output Data Tool is designed to specify the maximum number of records that will be written to a single output file. This setting is particularly useful when dealing with large datasets, as it allows users to split the output into multiple files based on the defined record limit. By indicating a specific maximum number of records, you can manage file sizes efficiently and ensure that files remain manageable for both storage and processing, which is critical in data handling and reporting scenarios.

While other options describe different functionalities, they do not accurately encompass the primary purpose of the 'Max Records Per File' setting, which focuses solely on the count of records in each output file, rather than size or sorting features.