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

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 some different alternative commands associated with "dsjob"?

764


What are the functionalities of link partitioner?

716


How to reverse the string using SQL?

984


Differentiate between datastage and informatica?

844


Can you explain kafka connector?

888






What are the functionalities of link collector?

724


How a routine is called in datastage job?

704


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

680


What are the types of views in datastage director?

1396


What is process model?

1628


I have a few records just I want to store data in to targets cycling way how?

2003


Explain usage analysis in datastage?

741


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

1099


What are the different common services in datastage?

826


What are constraints and derivations?

768