Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
- 2 Answers
- 13260 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rayudu
$$$SessStartTime is a string type data type and
SessStartTime is Date?Time Data type.
Regards,
rayudu.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / soundarya
we can use $$$SessStartTime in Mapping or mapplet filter
conditions
User-defined joins
SQL overrides
in designer and workflow manger also
We can use SESSSTARTTIME in Expresion in the designer
| Is This Answer Correct ? | 5 Yes | 0 No |
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
What is the difference between Active and Passive transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is galaxy shema
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
Is it possible to define a single node as a Gateway node as well as worker node?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
What is the procedure for creating independent data marts from informatica 7.1?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
what is casual dimension?
How to elaborate powercenter integration service?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Teradata 
