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
- 2656 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 |
With out using Funnel Stage, how to populate the data from different sources to single target
Differentiate between datastage and informatica?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
Could anyone give brief explanation bout datastage admin
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
Difference between the Sequence and Sequencer in DS?
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
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
what is the difference between the join and look up explin me one exmple
What is the project in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
Teradata 
