Hi This is Vijay,

How can your remove the duplicates in sequential File?

Answer Posted / venugopal

Hi Vijay it's simple

In the source sequential file goto Output->Properties
under options you mention reject mode = Output.

This will gives the duplicate records in the output.

This will 100% work why because in my present project we
are using the same format.

Is This Answer Correct ?    3 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to read the length of word in unix?

972


What is usage analysis in datastage?

915


how to export or import the jobs in .ISX file

826


What is a merge?

757


Why fact table is in normal form?

771






How to reverse the string using unix?

2928


options available in sequence job to run,validate?

942


why do u need the IOS upgradation in a FC switch

1959


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1225


What is ds designer?

762


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

734


How do you reject records in a transformer?

723


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2810


What is the difference between hashfile and sequential file?

815


Whats difference betweeen operational data stage (ods) and data warehouse?

755