Whats the difference between $, $$, $$$
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 |
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
What is the difference between IN and Exists in Oracle?
There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.
How can you increase the performance in joiner transformation?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
What is lookup transformation?
What does reusable transformation mean?
Using Expression transformation how to remove duplicate records from a relational source?
What are the types of lookup?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,