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 |
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
9 Answers BirlaSoft, Genpact, L&T, Syntel,
How to load duplicate records in to a target table which has a primary key?
what are presession,postsession success and postsession failure commands ?
what is flat file override?
Explain what are the different versions of informatica?
How many mapplets u have created? and what is the logic used
How to convert multiple rows to single row (multiple columns) in informatica
Can you use flat files in Mapplets.
What is Collect performance data in informatica and what is the use of it.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How can u stop a batch?