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  

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

---

Have you used Unstructured data?

0 Answers   CTS,

---

difference between function and procedure...

1 Answers   IBM,

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---

Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,

---

Differentiate between datastage and datastage tx?

0 Answers  

---

How to clean the datastage repository?

0 Answers  

---

What is the precedence of stage variables,derivations, and constraints?

0 Answers  

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

what is the differeces between hash and modulus partition methods

4 Answers   TCS,

---