What is the difference between Informatica parameters?

informatica informatica-powercenter
jrara picture jrara · Oct 24, 2013 · Viewed 10.1k times · Source

What is the difference between $myvar and $$myvar parameters in Informatica PowerCenter?

Answer

ymog picture ymog · Nov 4, 2013

Actually $ means internal Parameter/Variable (such as $DBConnection prefix or $PMSessionLogDir) whereas $$ are used for user-defined parameters or variables (which could be defined at mapping or workflow/worklet level).

You can declare and use variables and parameters starting with $$ You can override and use pre-defined parameters starting with $PM* (i.e. $PMSessionLogDir, $PMWorkflowLogCount) You can use without declaration parameters following predefined templates (i.e. $InputFile, $DBConnection, etc.).

I hope this all make more sense to you.

Regards,

-- YM

Related questions

Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I …

Read More
How to dynamically give flat file source file name in session properties of informatica?

i have an issue where i get flat file with date and time extension to flat file name like test_28-10-2012.txt I can get the flat file name in mapping through checking the AddCurrentlyProcessedFileNameproperty in Source Analyzer,from …

Read More
Difference between Joiner and Union Transformation

I'm new to Informatica....What is the difference between Joiner and Union Transformation? Also, Should we use Router instead of Joiner, to increase performance when there are multiple sources?

Read More