Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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.

Question Posted / geepee


Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:4..

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

Post New Answer

More Data Stage Interview Questions

How many types of hash files are there?

0 Answers  

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

how do u reduce warnings

1 Answers   CGI,

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

Why do we use exception activity in Datastage?

0 Answers  

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,

Differentiate between datastage and informatica?

0 Answers  

what about data stage requirement

1 Answers  

Could anyone give brief explanation bout datastage admin

0 Answers  

Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers   Wipro,

For more Data Stage Interview Questions Click Here
Categories