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

Configuring Source Properties

Configuring Source Properties

You can define session source properties on the Properties settings on the Mapping tab.
The following table describes the properties you define for flat file source definitions:
File Source Options
Description
Input Type
Type of source input. You can choose the following types of source input:
  • File. For flat file, COBOL, or XML sources.
  • Command. For source data or a file list generated by a command.
You cannot use a command to generate XML source data.
Source File Directory
Directory name of flat file source. By default, the Integration Service looks in the service process variable directory, $PMSourceFileDir, for file sources.
If you specify both the directory and file name in the Source Filename field, clear this field. The Integration Service concatenates this field with the Source Filename field when it runs the session.
You can also use the $InputFile
Name
session parameter to specify the file location.
Source File Name
File name, or file name and path of flat file source. Optionally, use the $InputFile
Name
session parameter for the file name.
The Integration Service concatenates this field with the Source File Directory field when it runs the session. For example, if you have “C:\data\” in the Source File Directory field, then enter “filename.dat” in the Source Filename field. When the Integration Service begins the session, it looks for “C:\data\filename.dat”.
By default, the Workflow Manager enters the file name configured in the source definition.
Source File Type
Indicates whether the source file contains the source data, or whether it contains a list of files with the same file properties. You can choose the following source file types:
  • Direct. For source files that contain the source data.
  • Indirect. For source files that contain a list of files. When you select Indirect, the Integration Service finds the file list and reads each listed file when it runs the session.
Command Type
Type of source data the command generates. You can choose the following command types:
  • Command generating data for commands that generate source data input rows.
  • Command generating file list for commands that generate a file list.
Command
Command used to generate the source file data.
Set File Properties link
Overrides source file properties. By default, the Workflow Manager displays file properties as configured in the source definition.
Truncate string null
Strips the first null character and all characters after the first null character from string values.
Enable this option for delimited flat files that contain null characters in strings. If you do not enable this option, the PowerCenter Integration Service generates a row error for any row that contains null characters in a string.
Default is disabled.

0 COMMENTS

We’d like to hear from you!