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 |
What is batch and describe about types of batches?
What are the diffrences between joiner transformation and source qualifier transformation?
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.
what is the use of Data Mart?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Different sorts of metadata that stores in the storage facility?
define galaxy repository in informatica
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 ?
What are the types of maping in Getting Started Wizard?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is a poling?
Differentiate between a repository server and a powerhouse?