top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What is the difference between Informatica parameters?

+1 vote
72 views

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

posted Apr 7, 2014 by Pooja Bhanout

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

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.

answer Apr 8, 2014 by Shweta Singh
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...