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

Parameter File Example

Parameter File Example

The example in this section describes a session in which you may want to use a parameter file. The session can be rerun with different state and time values. The example shows the parameters and variables you may want to set, lists the parameter and variable values, and explains what to change when you rerun the session.
You have a session, s_MonthlyCalculations, in the Production folder. The session uses session parameters to connect to source files and target databases and to write a session log file. If the session fails, the Integration Service sends an email message to pcadmin@mail.com. The session uses a string mapping parameter, $$State, that you set to “MA,” and a datetime mapping variable, $$Time. $$Time has an initial value of “9/30/2005 05:04:00” in the repository, but you override this value to “10/1/2005 05:04:11.”
The following table describes the parameters and variables for the s_MonthlyCalculations session:
Parameter or Variable Type
Parameter or Variable Name
Definition
Service Variable
$PMFailureEmailUser
pcadmin@mail.com
String Mapping Parameter
$$State
MA
Datetime Mapping Variable
$$Time
10/1/2005 05:04:11
Source File (Session Parameter)
$InputFile1
Sales.txt
Database Connection (Session Parameter)
$DBConnection_Target
Sales
Session Log File (Session Parameter)
$PMSessionLogFile
d:/session logs/firstrun.txt
The parameter file for the session includes the folder and session name and each parameter and variable:
[Production.s_MonthlyCalculations] $PMFailureEmailUser=pcadmin@mail.com $$State=MA $$Time=10/1/2005 05:04:11 $InputFile1=sales.txt $DBConnection_target=sales $PMSessionLogFile=D:/session logs/firstrun.txt
The next time you run the session, you might edit the parameter file to change the state to MD and delete the $$Time variable. This allows the Integration Service to use the value for the variable that the previous session stored in the repository.


Updated June 03, 2019