Procedure
-
Double-click tFileInputDelimited to display the
Basic settings view and define the component
properties.
-
In the File name/Stream field, browse to the file
to be used as the main input.
This file provides some information about customers.
- Define the row and field separators and the header and footer in the corresponding fields, if any.
-
Click the [...] button next to Edit schema to open a dialog box and define the input schema.
In this example, according to the input file structure, the schema is made of ten columns.
- Click the [+] button and define the input columns in the dialog box as in the above figure. Click OK to close the dialog box.
- If needed, right-click tFileInputDelimited and select Data Viewer to display a view of the input data.