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

Configuring Target File Properties

If you write to target files with FTP or SFTP, specify the target file properties after you specify the FTP or SFTP connection object for the target instance. The target file properties determine the reject file and directory and staging location. Specify target file properties in the Properties settings on the Mapping tab.
If you want to stage the target file, configure the target file name and directory and the reject file name and directory. If you do not stage the target file, configure the reject file and directory. The PowerCenter Integration Service uses the remote file name and directory from the FTP connection object.
If you have the Partitioning option, you can also select merge file properties.
  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 target file properties in the Properties settings of the Targets node on the
    Mapping
    tab:
    Attribute
    Description
    Output File Directory
    Name and path of the local target file directory used to stage the target data. By default, the PowerCenter Integration Service uses the service process variable directory, $PMTargetFileDir. The PowerCenter Integration Service concatenates this field with the Output file name field when it runs the session.
    If you do not stage the target file, the PowerCenter Integration Service uses the file name and directory from the FTP connection object.
    The PowerCenter Integration Service ignores this field if you enter a fully qualified file name in the Output file name field.
    Output File Name
    Name of the local target file used to stage the target 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 Output 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.
  9. Click
    Apply
    .
  10. To close the
    Edit Tasks
    dialog box, click
    OK
    .
  11. To save the changes in the target file properties, click
    Repository
    Save
    .

0 COMMENTS

We’d like to hear from you!