What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
Answer Posted / 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 View All Answers
What is rank transformation in informatica
What is aggregate cache in aggregator transformation?
How might one distinguish in the case of mapping is right or not without associating session?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is xml source qualifier transformation in informatica?
What is the function of aggregator transformation?
What is the meaning of decode in informatica?
What is the function of union transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
In informatica workflow manager, how many repositories can be created?
What is a repository manager?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explain the pipeline partition with real time example?
How to load the data from people soft hrm to people soft erm using informatica?
What does role playing dimension mean?