This step reads from a Java properties files. For more information on this file format, read this : http://en.wikipedia.org/wiki/.properties
The files tab is where you define the location of the files from which you want to read.
The table below contains options associated with the Files tab:
Name of the step; the name has to be unique in a single transformation.
Filenames from field
File or directory
Specifies the location and/or name of the input text file.
Specifies the regular expression you want to use to select the files in the directory specified in the previous option.
Contains a list of selected files (or wildcard selections) and a property specifying if file is required or not. If a file is required and it is not found, an error is generated;otherwise, the file name is skipped.
Displays a list of all files that will be loaded based on the current selected file definitions
Include filename in output?
Allows you to specify a field name to include the file name (String) in the output of this step.
Rownum in output
Allows you to specify a field name to include the row number (Integer) in the output of this step.
Reset rownum per file?
Enable this option if you want the generated row number (optional) to be reset (to 1) at the start of every individual file.
Limits the number of rows to this number (zero (0) means all rows).
The name of the output field
The attribute to read
The data type to convert to
The format or conversion mask to use in the data type conversion
The length of the output data type
The precision of the output data type
The currency symbol to use during data type conversion
The numeric decimal symbol to use during data type conversion
The numeric grouping symbol to use during data type conversion
The type of trimming to use during data type conversion
Repeat the column value of the previous row if the column value is empty (null)