top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the difference between Informatica parameters?

+1 vote
304 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 LinkedIn 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
...