Editing a Complex Flat File stage as a source

To edit a Complex Flat File stage as a source, you must provide details about the file that the stage will read, create record definitions for the data, define the column metadata, specify record ID constraints, and select output columns.

1. Open the CFF stage editor.
2. On the Stage page, specify information about the stage data:
   1. On the File Options tab, provide details about the file that the stage will read.
   2. On the Record Options tab, describe the format of the data in the file.
   3. If the stage is reading a file that contains multiple record types, on the Records tab, create record definitions for the data.
   4. On the Records tab, create or load column definitions for the data.
   5. If the stage is reading a file that contains multiple record types, on the Records ID tab, define the record ID constraint for each record.
   6. Optional: On the Advanced tab, change the processing settings.
3. On the Output page, specify how to read data from the source file:
   1. On the Selection tab, select one or more columns for each output link.
   2. Optional: On the Constraint tab, define a constraint to filter the rows on each output link.
   3. Optional: On the Advanced tab, change the buffering settings.
4. Click OK to save your changes and to close the CFF stage editor.