for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

0 Answers  

---

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

---

what is a force compile

2 Answers   Cap Gemini, IBM,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

0 Answers   Wipro,

---

what is the use of materialized view?

0 Answers   CTS,

---

how to find no.of records in sequntial file itself?

4 Answers  

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---

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

2 Answers  

---

What are the repository tables in datastage?

0 Answers  

---

What are the various kinds of containers available in datastage?

0 Answers  

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

0 Answers  

---

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  

---