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
- 2551 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to use Environment variable's in datastage?(use of process)
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
how can you generate sequence number using only the sequential file stage?
What is the difference between Link collector and Funnel Stages?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
which is the most complex job in your career? Please tell me answer?
how to find out number of records imported into source file?
What are stage variables?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is aggtorec restructure operator?
what is the difference between the active datawarehouse and datawarehouse
Teradata 
