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

Advanced Workflow Guide

Advanced Workflow Guide

Configuring Source File Properties

Configuring Source File Properties

If you access source files with FTP or SFTP, configure the source file properties after you choose the FTP or SFTP connection object 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 want to stage the source file, select the source file name, directory, and file type.
If you do not want to stage the source file, specify the source file type. The PowerCenter Integration Service uses the remote file name and directory from the FTP connection object and ignores the source file name and directory.
  1. In the Workflow Manager, open the Task Developer and click
    Tasks
    Create
    .
  2. Select Session for the task type.
  3. Enter a name for the session task. Do not use the period character (.) in task names. Workflow Manager does not allow a task name with the period character.
  4. Click
    Create
    .
    The Task Developer creates the session task.
  5. In the
    Mappings
    dialog box, select the mapping you want to use in the Session task and click
    OK
    .
  6. Click
    Done
    .
  7. Open the session properties by double-clicking the icon in the workspace.
    The
    Edit Tasks
    dialog box appears.
  8. Configure the following source file properties in the Properties settings of the Sources node 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 PowerCenter Integration Service uses the service process variable directory, $PMSourceFileDir, for file sources. The PowerCenter 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 PowerCenter Integration Service uses the file name and directory from the FTP connection object configured for SFTP.
    The PowerCenter 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 PowerCenter Integration Service ignores the Source file directory field.
    If you do not stage the source file, the PowerCenter Integration Service uses the remote file name and default directory from the FTP connection object configured for SFTP.
  9. Click
    Apply
    .
  10. To close the
    Edit Tasks
    dialog box, click
    OK
    .


Updated June 25, 2020