Informatica - $ & $$ in Mapping or Parameter File

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 631 of 644

$ & $$ in Mapping or Parameter File

What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?

Total Answers and Comments: 10

Last Update: October 05, 2009 Asked by: SayanSaha

Sponsored Links

Best Rated Answer

—

Submitted by: anshu.gangwar

$ prefixes are used to denote session Parameter and variables and $$ prefixes are used to denote mapping parameters and variables

Above answer was rated as good by the following members:
malathid, y.dilip, richa_bi, avneeshrathor

September 15, 2008 22:25:59

rahmanmd

Member Since: September 2008 Contribution: 1

RE: $ & $$ in Mapping or Parameter File

$$ is used as a prefix to any parameter name.
$ is used as a prefix to any variable name.

Is this answer useful? Yes | No

0 3

Overall Rating: -3

September 29, 2008 02:03:36

Sudeep15

Member Since: September 2008 Contribution: 1

RE: $ & $$ in Mapping or Parameter File

The difference stated above is wrong. $$ is used both in variables as well as parameters. Please give the difference if anybody knows. Please do not give wrong answers.

Is this answer useful? Yes | No

September 30, 2008 13:13:29

mitta

Member Since: September 2008 Contribution: 1

RE: $ & $$ in Mapping or Parameter File

$ represent system defined variables.
$$ represent user defined variables

Correct me If I am wrong and also give if any one know more details.

Is this answer useful? Yes | No

0 2

Overall Rating: -2

September 30, 2008 15:28:40

anshu.gangwar

Member Since: September 2008 Contribution: 1

RE: $ & $$ in Mapping or Parameter File

$ prefixes are used to denote session Parameter and variables and $$ prefixes are used to denote mapping parameters and variables

Is this answer useful? Yes | No

4 0

Overall Rating: +4

January 08, 2009 00:59:17

gaurav2485

Member Since: January 2009 Contribution: 12

RE: $ & $$ in Mapping or Parameter File

$ is System Define and $$ is user define variable

Is this answer useful? Yes | No

0 2

Overall Rating: -2

February 03, 2009 01:04:42

suneel.kolamudi

Member Since: January 2009 Contribution: 3

RE: $ & $$ in Mapping or Parameter File

Genarally parameters is used to flexibley run the session.
$ means suppose we are using predefined variable then it comes $
Example :- $status succeeded.

$$means suppose we are using our own variables then it comes $$
Example : $$ABC succeeded

Thanks & Regards
Suneel.kolamudi

Is this answer useful? Yes | No

0 2

Overall Rating: -2

February 20, 2009 01:31:48

sameer_solidcore

Member Since: February 2009 Contribution: 3

RE: $ & $$ in Mapping or Parameter File

$ - is used to denote Server level Variables/Parameters.
$$ - is used to denote Mapping level Variable/Parameter.

This is the convention that we generally follow to differentiate between Server Level/Mapping Level variables or parameters.

Thus anything related to a server or execution related activities we use $ this means whenever we define any file name or any database name we use a single $ and whenever there is some variable related to mapping or mapplet we use $$

Is this answer useful? Yes | No

July 16, 2009 05:44:14

sahan

Member Since: July 2009 Contribution: 10

RE: $ & $$ in Mapping or Parameter File

$$ - Mapping parameters and variables
$ - Session parameters.

Is this answer useful? Yes | No

September 30, 2009 15:25:42

manoj_pathak

Member Since: September 2009 Contribution: 2

RE: $ & $$ in Mapping or Parameter File

$$ : Mapping Variable Mapping Parameter and USER DEFINED Workflow Variables.
$ : Session Parameter SYSTEM DEFINED Workflow Variables.