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
- 2652 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
What is the difference between validated and compiled in the datastage?
What are the steps required to kill the job in Datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How one source columns or rows to be loaded in to two different tables?
What are stage variables and constants?
What is difference between join, merge and lookup stage?
how to write server Routine coding?
What is the difference between the local container and shared container?
Highlight the main features of datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is the importance of the exception activity in datastage?
