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

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 batch and describe about types of batches?

2 Answers  


What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  


Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  


what is the use of Data Mart?

5 Answers   IBM,


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

0 Answers  






Different sorts of metadata that stores in the storage facility?

0 Answers  


define galaxy repository in informatica

0 Answers  


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


What are the types of maping in Getting Started Wizard?

1 Answers  


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


What is a poling?

2 Answers  


Differentiate between a repository server and a powerhouse?

0 Answers  


Categories