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. Appendix A: Session Properties Reference
  17. Appendix B: Workflow Properties Reference

Workflow Basics Guide

Workflow Basics Guide

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

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

The Integration Service does not write data in unconnected ports to fixed-width files. For example, a fixed-width flat file target definition contains the following ports:
  • EmployeeID
  • EmployeeName
  • Street
  • City
  • State
In the mapping, you connect only the EmployeeID and EmployeeName ports in the flat file target definition. You configure the flat file target definition to create a header row with the output port names. The Integration Service generates an output file with the following rows:
EmployeeID
EmployeeName
2367
John Baer
2875
Bobbi Apperley
If you want the Integration Service to write empty fields for the unconnected ports, create output ports in an upstream transformation that do not contain data. Then connect these ports containing null values to the fixed-width flat file target definition. For example, you connect the ports containing null values to the Street, City, and State ports in the flat file target definition. The Integration Service generates an output file with the following rows:
EmployeeID
EmployeeName
Street
City
State
2367
John Baer
-
-
-
2875
Bobbi Apperley
-
-
-

0 COMMENTS

We’d like to hear from you!