28.08.2019-519 views -Informatica Paramter File
Employing Parameter document
Using Work flow and Session Parameter Data file Simultaneously
Writer: Amit Singh Yadav Particular date written: 18/01/10 Declaration
I/We hereby declare that this doc is based on my/our personal experiences and/or encounters of my/our project members. To the best of my/our expertise, this file does not have any materials that infringes the copyrights of any other individual or organization. Amit Singh Yadav
Target visitors: All
Keywords: Informatica Unbekannte File, $PMMergeSessParamFile, workflow, informatica, parameter record, session, mix files
Using Variable file The battle is to use program level parameter file and workflow level parameter file at the same time. The challenge being that when you define a workflow parameter file and a session unbekannte file for a session within the work flow, the Integration Service uses the workflow unbekannte file, and ignores the session parameter file. Treatment Parameter Data file: It contains session parameters that have values that could change from session to period, such as data source connections or file labels. $PMSessionLogFile and $ParamName will be user-defined session parameters. As well variables that people use in supply queries like date requirements e. g. $$Lastrun Work flow Parameter Document It contains workflow level variables. For example , you can use a workflow variable within a Decision process to determine whether or not the previous activity ran effectively. In a work, $TaskName. PrevTaskStatus is a predetermined workflow variable and bucks $SessionName is a user-defined work variable.
Applying both session and workflow level parameter file. Initially let me tell you so why we need both the parameter data files in our work. Recently we all decided to employ third party scheduling tool, Workload Manager (WLM), scheduling product by LOS ANGELES Inc. WLM schedules careers across programs e. g. dependent jobs across Informatica, teradata, UNIX MF may be scheduled jointly. Now the requirement of this...
References: Informatica Assist