Answer Posted / chandrakant swain (hara)

suppose we have one file HSBC.ds ,having 5 fields or
columns,and
20 records,for deleting the all record
then

>$head -1 HSBC.ds > NEW_HSBC.ds
then rename the new file use mv command ,like this mannaer
>$mv NEW_HSBC.ds HSBC.ds

How to read multiple files using a single datastage job if files have the same metadata?

1252

---

How a server job can be converted to a parallel job?

1096

---

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)

921

---

Which algorithm you used for your hashfile?

1186

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2814

---

What is merge stage?

1318

---

How many types of sorting methods are available in datastage?

1075

---

Where do the datastage jobs get stored?

1218

---

Can you filter data in hashed file?

3778

---

what is the custome stage in datastage? how can we impliment that one? plz tell me

2369

---

How do you import and export data into datastage?

1238

---

What is ibm datastage flow designer?

1152

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2048

---

What is the differentiate between data file and descriptor file?

1365

---

What is a quality stage in datastage tool?

1079

---