Workflow Basics Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5

Back Next

Integration Service Handling for File Targets

When you configure a session to write to file targets, you must correctly configure the flat file target definitions and the relational target definitions. The Integration Service loads data to flat files based on the following criteria:

Write to fixed-width flat files from relational target definitions.
The Integration Service adds spaces to target columns based on transformation datatype.

Write to fixed-width flat files from flat file target definitions.
You must configure the precision and field width for flat file target definitions to accommodate the total length of the target field.

Generate flat file targets by transaction.
You can configure the file target to generate a separate output file for each transaction.

Write empty fields for unconnected ports in fixed-width file definitions.
You can configure the mapping so that the Integration Service writes empty fields for unconnected ports in a fixed-width flat file target definition.

Write multibyte data to fixed-width files.
You must configure the precision of string columns to accommodate character data. When writing shift-sensitive data to a fixed-width flat file target, the Integration Service adds shift characters and spaces to meet file requirements.

Null characters in fixed-width files.
The Integration Service writes repeating or non-repeating null characters to fixed-width target file columns differently depending on whether the characters are single-byte or multibyte.

Character set.
You can write ASCII or Unicode data to a flat file target.

Write metadata to flat file targets.
You can configure the Integration Service to write the column header information when you write to flat file targets.

Targets

Writing to Fixed-Width Flat Files with Relational Target Definitions

Writing to Fixed-Width Files with Flat File Target Definitions

Generating Flat File Targets By Transaction

Writing Empty Fields for Unconnected Ports in Fixed-Width File Definitions

Writing Multibyte Data to Fixed-Width Flat Files

Null Characters in Fixed-Width Files

Character Set

Writing Metadata to Flat File Targets

Download Guide

Watch

Comments