Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers  

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---

---

How a source file is populated?

0 Answers  

---

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,

---

hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage

1 Answers   Wipro,

---

Give example for FACTLESS FACT TABLE in real-time scenario.

4 Answers   TCS,

---

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  

---

What r the existing server jobs in parallalism?

0 Answers   ITC Infotech,

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---