What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
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 |
Enlist the various types of transformations.
What are the guidelines to be followed while using union transformation?
I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
disable caching in a lookup transformation?
what is informatica metadata?
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
what is datamart
What is the difference Between Mapping parameter and variable
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
Which kind of index is preferred in DWH?