Answer / j madhava rao

$sort -u filename will sorts the data and removes the duplicates lines from the output

Answer / vishwababu

You can use UNIQ to remove duplicates frm a file but it can
consider only same consecutive records.
Ex: if u hve records as
1 vishwa
1 Shruti
2 Ravi
3 Naveen
1 vishwa
and if u use UNIQ cmd, then you wil get vishwa, Ravi, Naveen
and vishwa.
So perform sort before using UNIQ so tat to avoid duplicates

Answer / prasad

Uniq -u File_name

It will remove duplicates records.

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

---

what is use of SDR function?

0 Answers   CGI,

---

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

What is the default padding character?

3 Answers   IBM,

---

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

3 Answers   TCS,

---

Why do we use link partitioner and link collector in datastage?

0 Answers  

---