Editing a Complex Flat File stage as a target

To edit a CFF stage as a target, you must provide details about the file that the stage will write, define the record format of the data, and define the column metadata.

  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 write.
    2. On the Record Options tab, describe the format of the data in the file.
    3. On the Records tab, create or load column definitions for the data.
      See Column definitions for information about how to define columns.
    4. Optional: On the Advanced tab, change the processing settings.
  3. Optional: On the Input page, specify how to write data to the target file:
    1. On the Advanced tab, change the buffering settings.
    2. On the Partitioning tab, change the partitioning settings.
  4. Click OK to save your changes and to close the CFF stage editor.