Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 2622 Views
- I also Faced
- E-Mail Answers
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
how to export or import the jobs in .ISX file
How many Key we can define in remove duplicate stage?
What is a datastage job?
Different ways a project can be moved to production ?...example ….export-import and Version control.
what are the errors,warnings in datastage
What are the types of containers in datastage?
Describe the architecture of datastage?
Define repository tables in datastage?
What is the differentiate between data file and descriptor file?
How many types of views are there in a datastage director?
Describe link sort?
What is the difference between hashfile and sequential file?
What all the types of jobs you developed?
What is datastage?
how to write server Routine coding?
