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

Answer Posted / chandu

in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of views in datastage director?

1256


how do u catch bad rows from OCI stage? And what CLI stands for?

2298


How you Implemented SCD Type 1 & Type 2 in your project?

3703


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1644


What are the types of containers?

701






What is merge stage?

775


How many types of hash files are there?

622


How to manage date conversion in Datastage?

652


What is difference between symmetric multiprocessing and massive parallel processing?

664


how to sort two columns in single job in datastage.

2553


How to read multiple files using a single datastage job if files have the same metadata?

748


what is 'reconsideration error' and how can i respond to this error and how to debug this

2127


How the ipc stage work?

682


Demonstrate experience in maintaining quality process standards?

1953


What is the sortmerge collector?

672