Emp login_timestamp Logout_timestamp
A,2019-02-01 02:24:15,2019-02-01 04:59:42
B,2019-03-29 14:43:30,2019-03-29 20:22:00
ABC,2019-03-29 12:43:00,2019-03-29 23:22:59
In the above calculate the duration of hours spent in office for each emp in datastage.
Answer Posted / geepee
Transfromer Fun:
The above scenario can be solved using transformer stage date functions.
Stagervar1: SecondsSinceFromTimestamp(DSLink3.Logout_timestamp, DSLink3.login_timestamp) - Float datatype
Duration: TimeFromMidnightSeconds(StageVar1) -- Time datatype
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is flow of project?
What is data partitioning?
What is the process of killing a job in datastage?
What is a quality stage in datastage tool?
What is apt_config in datastage?
How the ipc stage work?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How do you import and export the datastage jobs?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Why fact table is in normal form?
What is difference between server jobs & parallel jobs?
Lookup constraints
Demonstrate experience in maintaining quality process standards?
Differentiate between data file and descriptor file?
What is the different type of jobs in datastage?