Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data
  26. POWERCENTERHELP

Advanced Workflow Guide

Advanced Workflow Guide

Configuring File Properties

Configuring File Properties

Use the Properties settings in the Transformations view on the Mapping tab to configure file properties for flat file sources.
The following table describes the file properties for file targets in a mapping:
Attribute
Description
Merge Type
Type of merge that the Integration Service performs on the data for partitioned targets.
When merging target files, the Integration Service writes the output for all partitions to the merge file or a command when the session runs.
You cannot merge files if the session uses an external loader or a message queue.
Merge File Directory
Location of the merge file. Default is $PMTargetFileDir.
Merge File Name
Name of the merge file. Default is
target name.out
.
Append if Exists
Appends the output data to the target files and reject files for each partition. Appends output data to the merge file if you merge the target files. You cannot use this option for target files that are non-disk files, such as FTP target files.
If you do not select this option, the Integration Service truncates each target file before writing the output data to the target file. If the file does not exist, the Integration Service creates it.
Output Type
Type of target for the session. Select File to write the target data to a file target. Select Command to send target data to a command. You cannot select Command for FTP or queue target connection.
Header Options
Create a header row in the file target.
Header Command
Command used to generate the header row in the file target.
Footer Command
Command used to generate a footer row in the file target.
Merge Command
Command used to process merged target data.
Output File Directory
Location of the target file. Default is $PMTargetFileDir.
Output File Name
Name of target file. Default is
target name partition number.out
. You can also use the session parameter, $OutputFile
Name
, as defined in the parameter file.
Reject File Directory
Location for the target reject files. Default is $PMBadFileDir.
Reject File Name
Name of reject file. Default is
target name partition number.bad
.
You can also use the session parameter, $BadFile
Name
, as defined in the parameter file.
Command
Command used to process the target output data for a single partition.


Updated July 04, 2018