Hi This is Vijay,

How can your remove the duplicates in sequential File?

Answer Posted / arun

Sort the incoming data using a sort stage & use remove
duplicates on the key columns. This will remove the
duplicates in ur source file.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1880


How the ipc stage work?

755


Define repository tables in datastage?

785


What is data partitioning?

831


What are the types of jobs we have in datastage?

761






How can we improve performance of data stage jobs?

696


Different ways a project can be moved to production ?...example ….export-import and Version control.

2056


What are the primary usages of datastage tool?

721


What is the importance of the exception activity in datastage?

721


Is it possible to query a hash file?

1653


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2378


What are routines in datastage? Enlist various types of routines.

727


What are some prerequisites for datastage?

707


How one source columns or rows to be loaded in to two different tables?

763


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

680