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 Source File Properties

Configuring Source File Properties

If you access source files with FTP, configure the source file properties after you choose the FTP connection for the source instance. The source file properties determine the source file type and the staging location. You can configure source file properties in the Properties settings on the Mapping tab.
If you stage the source file, select the source file name, directory, and file type.
If you do not stage the source file, specify the source file type. The Integration Service uses the remote file name and directory from the FTP connection object and ignores the source file name and directory.
The following table describes the source file properties on the Mapping tab:
Attribute
Description
Source File Type
Indicates whether the source file contains the source data or a list of files with the same file properties. Choose Direct if the source file contains the source data. Choose Indirect if the source file contains a list of files.
Source File Directory
Name and path of the local source file directory used to stage the source data. By default, the Integration Service uses the service process variable directory, $PMSourceFileDir, for file sources. The Integration Service concatenates this field with the Source file name field when it runs the session.
If you do not stage the source file, the Integration Service uses the file name and directory from the FTP connection object.
The Integration Service ignores this field if you enter a fully qualified file name in the Source file name field.
Source File Name
Name of the local source file used to stage the source data. You can enter the file name or the file name and path. If you enter a fully qualified file name, the Integration Service ignores the Source file directory field.
If you do not stage the source file, the Integration Service uses the remote file name and default directory from the FTP connection object.


Updated July 04, 2018