This step can be used to perform various types of aggregations such as sum, average, min, max e.t.c. Input data always need to be sorted for this step to work properly.
CSV file input is a commonly used input step to read delimited files. Options are similar to text file input steps. Here are the general configurable options.
File name - Input file name.
Delimiter - Support common delimiters like coma, tab, pipe e.t.c
Enclosure - Optional enclosures like double quotes.
NIO buffer size - Read buffer size.
Lazy Conversion - Significant performance improvement by avoiding data type conversions. Check this option only if the logic is mere pass through.