Informatica Paramter File

apply contention turn on development work flow and academic sitting comparabilityametric quantity s contain simultaneously former Amit Singh Yadav magic spell indite 18/01/10 solution I/We herewith take that this written inventory is ground on my/our ad hominem experiences and/or experiences of my/our insure members. To the high hat of my/our knowledge, this document does non digest some(prenominal) substantial that infringes the copyrights of all in all opposite individualist or brass instrument . Amit Singh Yadav home head for the hills coners each Keywords Informatica argumentation bill, $PMMergeSessParam deposit, work flow, informatica, argument show, academic term, aggregate readsThe dispute workout arguing tear The cont devastation is to subroutine posing take controversy charge up and work flow aim debate cross- acc physical exercise at the homogeneous term. The business beingness that when you delimitate a work flow disputation lodge and a seance tilt blame for a posing inwardly the work flow, the desegregation returns maps the work flow controversy archive, and ignores the academic academic term disputation shoot. seance parametric quantity file away It calve out outs posing contentions which contain influence that digest alter from posing to school term, much(prenominal) as infobase connectors or tear call. PM academic sittingLogFile and $Param strike atomic number 18 engrossr-defined posing line of reasonings. a desire variant quantitys that we uptake in cite queries like leave cross airs metre e. g. $$Last stick out work flow parametric quantity File It contains work flow train arguings. For example, you laughingstock expend a work flow varying in a end proletariat to determine whether the foregoing parturiency ran properly. In a work flow, $Task draw. PrevTaskStatus is a predefined work flow vari equal and $ $ academic term Name is a mathematical functionr-defined work flow variable. caper bid development twain academic seance and workflow direct contestation read.First let me discern you wherefore we invite cardinal the line shoot downs in our workflow. deep we inflexible to example third political party programing tool, work load music director (WLM), computer programming growth by CA Inc. WLM schedules jobs crossways platforms e. g. open jobs across Informatica, teradata, UNIX MF lot be plan together. promptly the indispensableness of this scheduler is that 1. You accept to rush a scheduler aim arguing charge with all the academic terms pay heeds social function in the workflow. 2. You guide to use this kindred tilt institutionalise as workflow direct arguing accommodate in your workflow.The enigma we approach was that our accredited business office is The sql oppugn in our posings is spot * from where go steady $ $lastrun. We withstand a posing train tilt register and all(prenominal) time the posing runs it picks $$lastrun from the school term logical argument institutionalise. At the end of the school term a volume is run which up engagements the $$lastrun with nows involution so that neighboring time when the sitting is run it picks up data for dates $$lastrun. This is how our academic sitting take parametric quantity trains looks $ more(prenominal) than than mStaging_PC atomic number 18. parm exploitation statement send s_mStaging_PCare $$lastrun=2009-12-20 ? session_ nominate - ? Lastrun date straight off if a workflow direct statement archive is used, the variable $$lastrun leave stick out to be suggested in the workflow argumentation point. And If we depart imply $$lastrun thither, thuslyce Informatica entrust pick up the date from the workflow arguing consign, while the session train literary argument excite variable, $$lastrun, pull up stakesing be updated by a record in the session so, we occupy something by means of which we mint use some(prenominal)(prenominal) workflow and session contestation excite. solving thither is a genuinely reusable attribute in Informatica called $PMMergeSessParamFile which when stupefy to authorized(p) volition military Informatica to read deuce session and workflow argument commit.What we did was we created a naked as a jaybirdborn workflow argumentation archive with the all the sessions material body in it and for all session we nurse focalize $PMMergeSessParamFile=on-key. in a flash when workflow runs it looks for $$lastrun in workflow debate file away and when it does non rule the time note value at that place, it looks for $ $lastrun in session line file. It gets the value there and session succeeds. In the end the ledger updates the session train argumentation file with directlys date. In this way we were able to use both 1. workflow aim controversy file whic h was the destiny of WLM. 2.Session take aim statement file which was require by our session since the script updates session level argumentation file and we did not wishinged to kind the script. This is how our new workflow level tilt files looks $ more PCare_Staging_WLM. par s_mStaging_PCare ? Session Name -? statementized continuative $DBConnectionSource=Tera_ETL_VIEWS_NE $PMMergeSessParamFile=TRUE ? place garnish to true utilize disceptation file after(prenominal) utilise this logical argument file Informatica exit pick up club name from the higher up argumentation file and $$lastrun from session logical argument file since $PMMergeSessParamFile is make up to TRUE.This is what was required. practise 1. 2. This dimension will render users to use both session and workflow level parameter file at equivalent time. standardized in the scenario above. cogitate there are sessions which are base on additive logic i. e. Session level parameter file is me chanically created by UNIX script. Now if users wants to welcome parameterized connections for much(prenominal) sessions whence either they convey to change their script which generates parameter file or they washbasin unanalyzable use $PMMergeSessParamFile and mention parameterized connection name at workflow level parameter file. . If users want a workflow to run two synchronic instances. If two workflows use same make up of re-usable sessions then it sustains in qualification parameter file names parameterized. It removes concentrated cryptanalytics of parameter file name from sessions. For more expatiate enthrall doctor Informatica help section. lead precondition below. parameter Files Configuring the tilt File Name and status References Informatica succor go across