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

3 Answers
9929 Views
I also Faced
E-Mail Answers

Answer Posted / subhash

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

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different common services in datastage?

1213

How to find value from a column in a dataset?

2147

What is the difference between odbc and drs stage?

1042

How can we improve performance of data stage jobs?

965

What is the purpose of pivot stage and types of containers in datastage

996

EXPLAIN SCD

1338

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1367

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2164

What is datastage engine?

1118

What are the functionalities of link partitioner and link collector?

949

How we can covert server job to a parallel job?

1060

What are the functionalities of link partitioner?

971

what is use of SDR function?

5126

What is datastage?

1028

what is ds administrator used for?

1112