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

explain about citrix scheduling tool in datastage

1911

---

What is the use of hoursfromtime() function in transformer stage in datastage?

668

---

Give an idea of system variables.

684

---

How do you import and export data into datastage?

795

---

How to RD using transformer?

960

---

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1099

---

How many types of sorting methods are available in datastage?

718

---

How you can fix the truncated data error in datastage?

1291

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

443

---

How do y read Sequential file from job control?

14752

---

What can we do with datastage director?

769

---

Difference between server jobs & parallel jobs?

755

---

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1736

---

Can you explain link buffering?

824

---

Where do the datastage jobs get stored?

825

---