how CAN we remove duplicates in dataset?

Answer Posted / disney

In dataset stage, Input tab of partitioning --> used the key
partition instead of auto partition , then check the
perform sort and check the unique, It will remove the
duplicate from dataset

Is This Answer Correct ?    25 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different type of jobs in datastage?

602


What are the differences between datastage and informatica?

568


What are the functionalities of link partitioner and link collector?

594


Where do the datastage jobs get stored?

727


What are datastage sequences?

668






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

707


How many types of sorting methods are available in datastage?

629


what are the errors,warnings in datastage

2145


What are the different types of lookups in datastage?

626


How to clean the datastage repository?

691


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3263


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

628


Define Routines and their types?

618


What is the difference between hashfile and sequential file?

715


How do u convert the columns to rows in datastage?

692