Whats the difference between $, $$, $$$

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / purva

9 Answers
45699 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Whats the difference between $, $$, $$$..

Answer / abidu

$ - session variable
$$ - mapping parameter & variable
$$$ - system variable

Is This Answer Correct ?

69 Yes

3 No

Whats the difference between $, $$, $$$..

Answer / rambabu

$-- session parameter and session variable
exmple-$dbconnection

$$--mapping parameters and mapping variables
exmple-$$deptno, $$sal

$$$--
exmple-$$$sessstarttime

Is This Answer Correct ?

24 Yes

0 No

Whats the difference between $, $$, $$$..

Answer / purva

$ - These are the system variables like $Bad file,$input
file, $output file, $DB connection

$$ - Can any one tell me the scenario with example for
user defined variables

$$$ - $$$SessStartTime

$$$SessStartTime returns the initial system date value on
the machine hosting the PowerCenter Server when the server
initializes a session. $$$SessStartTime returns the session
start time as a string value. The format of the string
depends on the database you are using.

Thank You

Is This Answer Correct ?

17 Yes

1 No

Whats the difference between $, $$, $$$..

Answer / rajeshkr7

Abidu is correct.

others - pls do not confuse people with wrong answers.

Is This Answer Correct ?

7 Yes

0 No

Whats the difference between $, $$, $$$..

Answer / sateesh

$ - Connection I nformation

$$ - Mapping parameters & Variables

$$$ - Sesion start time.

Is This Answer Correct ?

6 Yes

2 No

Whats the difference between $, $$, $$$..

Answer / g praveen kumar

Yes i agree with Abidu and Rajeshkr7. Please don't confuse with different answers.

correct answer is:

$ - session variable and parameter
$$ - mapping parameter & variable
$$$ - system variable

Is This Answer Correct ?

3 Yes

0 No

Whats the difference between $, $$, $$$..

Answer / gopal

$$ - is used for Parameter...see the below example

select a,b,c from <table> where <table>.date-$$date_filter

when you define parameter file in the src File directory
and this should be given in session, if in parameter file
if you give 10, then above query will be as below

select a,b,c from <table> where <table>.date-10

Is This Answer Correct ?

1 Yes

0 No

Whats the difference between $, $$, $$$..

Answer / praveen kumar pendekanti

$--- single doollar is system defiend variables

$$--- double dollar is user defined variabes

$$$--- No idea....(just send me if u know)

Is This Answer Correct ?

5 Yes

5 No

Whats the difference between $, $$, $$$..

Answer / frnd

Mr.purva is corrct,good going

Is This Answer Correct ?

3 Yes

4 No

Post New Answer