Answer Posted / vinoth

Adding to the above list.
cp
mv
awk
if
these are some frequently used commands in DS.

Lookup constraints

1246

---

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)

917

---

On which interface you will be working as a developer?

1038

---

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

1375

---

How to read the length of word in unix?

1373

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5110

---

Enlist various types of routines in datastage.

1241

---

What are the different common services in datastage?

1276

---

What are some prerequisites for datastage?

1088

---

In Datastage, how you can fix the truncated data error?

1150

---

What are the important features of datastage?

1114

---

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

1093

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2243

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2619

---

Explain connectivity between datastage with datasources?

966

---