Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

System Parameters

System Parameters

System parameters are constant values that define the directories where the Data Integration Service stores cache files, reject files, source files, target files, log files, and temporary files.
Define the values of some of the system parameters in the execution options for the Data Integration Service. An Administrator can update the values from the Administrator tool. The Data Integration Service determines the values of other system parameters at run time. You cannot override system parameter values in a parameter file or a parameter set.
You cannot create system parameters. The Developer tool provides a pre-defined list of system parameters that you can assign to a data object or transformation in a mapping. For example, when you create an Aggregator transformation, the cache directory system parameter is the default value assigned to the cache directory field in Informatica Administrator. If you want to use a different cache directory location, create a user-defined parameter and configure a default parameter value.
The Analyst tool displays the file path of system parameters in the following format:
$$[Parameter Name]/[Path]
. For example,
"$$SourceDir/ff_dept.txt."
The following table describes the system parameters:
System Parameter
Type
Description
CacheDir
String
Default directory for index and data cache files.
LogDir
String
Default directory for Mapping task log files.
RejectDir
String
Default directory for reject files.
SourceDir
String
Default directory for source files.
TargetDir
String
Default directory for target files.
TempDir
String
Default directory for temporary files.
ApplicationName
String
Name of the application
ExecutionEnvironment
String
Hadoop or Native environment.
MappingName
String
Name of the mapping that is running.
MappingRunStartTime
Date/time
The start time of the mapping that is running.
ServiceName
String
The Data Integration Service name.
UserName
String
Name of the user that is running the mapping.

0 COMMENTS

We’d like to hear from you!