Configuring the File connector as a target

You can configure the File connector to write rows to or delete rows from the file.

Procedure

  1. On the job design canvas, double-click the File Connector stage.
  2. Select the input link to edit.
  3. Configure the connector to write rows to or delete rows from a file.
    Table 1. Procedures for writing or deleting data from a file
    Action Procedure
    Write single file
    1. Set the Write mode property to Write single file.
    2. Specify the name of the file to write.
    Write multiple files
    1. Set the Write mode property to Write multiple files.
    2. Specify the base name of files to write. The connector customizes the name for each file it writes by using the specified base name as a template.
    Delete
    1. Set the Write mode property to Delete.
    2. Specify a text column on the input link. The connector deletes the file that is named in each row of the column.
  4. In the File format property, specify the file formatting options.
  5. Click OK, and then save the job.