Answer Posted / 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 |
Post New Answer View All Answers
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,
Explain informatica architecture - version 8 / 9
What is a shortcut and copy in Informatica and how two are different with each other?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How you know when to use a static cache and dynamic cache in lookup transformation?
What is native users?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain the different kinds of facts.
in reporting we add some new objects,how we get the count of the newly added objects to the report
Explain the types of lookup transformation?
Enterprise data warehouse your projects phase by phase explain?
what is index?how it can work in informatica
What is the difference between informatica 7.0 and 8.0?
How can informatica be used for an organization?