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
- 2649 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
Define data aggregation?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How do you reject records in a transformer?
What is the sortmerge collector?
Can you filter data in hashed file?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
I have a few records just I want to store data in to targets cycling way how?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
how to delete one row in target dataset
In Datastage, how you can fix the truncated data error?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Explain Quality stage?
What are the different options associated with dsjob command?
What is the use of datastage director?
Have you have ever worked in unix environment and why it is useful in datastage?
