Answer / sri

Using the Pivot we can convert the columns into rows

Answer / manu

By using 'ETERNAL PIVOT STAGE' we can do this

How to read the length of word in unix?

0 Answers   CTS,

---

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

What are routines in datastage? Enlist various types of routines.

0 Answers  

---

Describe stream connector?

0 Answers  

---

What is the use of datastage designer?

0 Answers  

---

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,

---

What are the repository tables in datastage?

0 Answers  

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

Where do you see different stages in the designer?

0 Answers  

---

What a datastage macro?

0 Answers  

---

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?

1 Answers   IBM,

---

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  

---