English
  • PowerCenter 10.2 HotFix 2
  • All Products

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

Workflow Basics Guide

Workflow Basics Guide

Back Next

Writing to Fixed-Width Flat Files with Relational Target Definitions

Writing to Fixed-Width Flat Files with Relational Target Definitions

When you want to output to a fixed-width file based on a relational target definition in the mapping, consider how the Integration Service handles spacing in the target file.
When the Integration Service writes to a fixed-width flat file based on a relational target definition in the mapping, it adds spaces to columns based on the transformation datatype connected to the target. This allows the Integration Service to write optional symbols necessary for the datatype, such as a negative sign or decimal point, without sending the row to the reject file.
For example, you connect a transformation Integer(10) port to a Number(10) column in a relational target definition. In the session properties, you override the relational target definition to use the File Writer and you specify to output a fixed-width flat file. In the target flat file, the Integration Service appends an additional byte to the Number(10) column to allow for negative signs that might be associated with Integer data.
The following table describes the number of bytes the Integration Service adds to the target column and optional characters it uses for each datatype:
Datatype Connected to Fixed-Width Flat File Target Column
Bytes Added by Integration Service
Optional Characters for the Datatype
Decimal
2
  • Negative sign (-) for the mantissa.
  • Decimal point (.).
Double
7
  • Negative sign for the mantissa.
  • Decimal point.
  • Negative sign, e, and three digits for the exponent, for example, -4.2-e123.
Float
7
  • Negative sign for the mantissa.
  • Decimal point.
  • Negative sign, e, and three digits for the exponent.
Integer
1
  • Negative sign for the mantissa.
Money
2
  • Negative sign for the mantissa.
  • Decimal point.
Numeric
2
  • Negative sign for the mantissa.
  • Decimal point.
Real
7
  • Negative sign for the mantissa.
  • Decimal point.
  • Negative sign, e, and three digits for the exponent.