SORT -u file_name.txt or SORT|UNIQ file

how to get the unique records on multiple columns by using
sequential file stage only

Question Posted / subhash

Answer Posted / subhash

SORT -u file_name.txt
or
SORT|UNIQ file_name.txt

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different common services in datastage?

1270

How to convert RGB Value to Hexadecimal values in datastage?

3982

Define data aggregation?

1084

what is the use of skid in reporting?

2366

What are the repository tables in datastage?

1291

What is the method of removing duplicates, without the remove duplicate stage?

1004

AGGREGATOR default datatype

1438

root tree will find which is server job and which is parallel job?

1945

What are the different plug-ins stages used in your projects?

1062

What are stage variables?

1191

Why fact table is in normal form?

1218

State the difference between an operational datastage and a data warehouse?

1122

How can you write parallel routines in datastage PX?

1001

Why do you need stage variables?

1170

Differentiate between odbc and drs stage?

1036