Answer Posted / venkat

We have two types of ways is there,
first one, we have to go dataset management in delete option
is there, and second one is via unix command
$orchadmin truncate[-f or -x] descriptor file name

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

1384

---

Why do we use exception activity in Datastage?

1317

---

What is difference between join, merge and lookup stage?

1100

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3797

---

How many types of sorting methods are available in datastage?

1075

---

What is the purpose of pivot stage?

1170

---

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

1161

---

How to RD using transformer?

1427

---

How to find value from a column in a dataset?

2203

---

what is use of SDR function?

5175

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3759

---

Describe link sort?

1018

---

Explain Quality stage?

1162

---

How many types of stage?

1181

---

Can you highlight the main features of ibm infosphere information server?

1088

---