1)How to Duplicate Records Delete in Sequential file?

Answer Posted / vinod upputuri

In the sequential File stage there is a option called filter.
there we can use UNIX command.

syntax for Remove duplicate: uniq or sort -u

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of stage?

678


what is repositery?

1297


What are the enhancements made in datastage 7.5 compare with 7.0?

709


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1619


Explain Quality stage?

671






What is the difference between an operational datastage and a data warehouse?

636


How to perform incremental load in datastage?

668


What is quality stage?

574


8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

1784


how to delete one row in target dataset

2588


How many types of views are there in a datastage director?

834


Explain the importance of surrogate key in data warehousing?

715


What are the repository tables in datastage?

826


In Datastage, how you can fix the truncated data error?

640


Can you implement SCD2 using join, transformer and funnel stage?

1089