Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Working with File Targets

Working with File Targets

You can output data to a flat file in either of the following ways:
  • Use a flat file target definition.
    Create a mapping with a flat file target definition. Create a session using the flat file target definition. When the Integration Service runs the session, it creates the target flat file or generates the target data based on the connected ports in the mapping and on the flat file target definition. The Integration Service does not write data in unconnected ports to a fixed-width flat file target.
  • Use a relational target definition.
    Use a relational definition to write to a flat file when you want to use an external loader to load the target. Create a mapping with a relational target definition. Create a session using the relational target definition. Configure the session to output to a flat file by specifying the File Writer in the Writers settings on the Mapping tab.
You can configure the following properties for flat file targets:
  • Target properties.
    You can define target properties such as partitioning options, merge options, output file options, reject options, and command options.
  • Flat file properties.
    You can choose to create delimited or fixed-width files, and define their properties.