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
- 1874 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
Nls stands for what in datastage?
What are the repository tables in datastage?
How many types of stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Explain Quality stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Explain usage analysis in datastage?
What are datastage sequences?
How to convert RGB Value to Hexadecimal values in datastage?
How do you generate sequence number in datastage?
On which interface you will be working as a developer?
What is merge stage?
What are constraints and derivations?
AGGREGATOR default datatype
Triggers,VIEW,Procedures
