Interested to Buy Any Domain ? << Click Here >> for more details...
Whats the difference between $, $$, $$$
- 9 Answers
- 45610 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 |
What is the Difference between PowerPlay transformer and power play reports?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to eliminate duplicates from flat file..what is the procedure
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?
Can we call a stored procedure from a unix script which is run using command task
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
what is mean by flag 4 in update strategy t/r
What is informatica?
Teradata 
