Interested to Buy Any Domain ? << Click Here >> for more details...
Whats the difference between $, $$, $$$
- 9 Answers
- 45983 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abidu
$ - session variable
$$ - mapping parameter & variable
$$$ - system variable
| Is This Answer Correct ? | 69 Yes | 3 No |
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 |
Answer / rajeshkr7
Abidu is correct.
others - pls do not confuse people with wrong answers.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sateesh
$ - Connection I nformation
$$ - Mapping parameters & Variables
$$$ - Sesion start time.
| Is This Answer Correct ? | 6 Yes | 2 No |
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 |
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 |
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 |
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What is the difference between sequential batch and concurrent batch and which is recommended and why?
What is meant by pre and post session shell command?
What is source qualifier?
list out all the transformations which use cache?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
why sequence generator should not directly connected to joiner transformation ?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
How will you update the row without using update statergy?
What is a snowflake schema?
What are the new features of informatica 9.x developer?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Teradata 
