Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

Question Posted / jeyakumar.uv

Answers were Sorted based on User's Feedback



What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?..

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

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?..

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

Post New Answer

More Informatica Interview Questions

What is the use of source qualifier?

0 Answers  

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

Define update strategy?

0 Answers  

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

What is Code Page Compatibility?

1 Answers  

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories