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
- 2547 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
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Define repository tables in datastage?
How many areas for files does datastage have?
Name the command line functions to import and export the DS jobs?
What are the different layers in the information server architecture?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How do you reject records in a transformer?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the difference between datastage and informatica?
How many types of views are there in a datastage director?
What is active and passive stage?
what is the use of skid in reporting?
What a datastage macro?
What is usage analysis in datastage?
Explain the importance of surrogate key in data warehousing?
