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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are the processing stages?
What is active and passive stage?
what is use of SDR function?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to clean the datastage repository?
Explain datastage architecture?
Difference between sequential file and data set?
what is the custome stage in datastage? how can we impliment that one? plz tell me
root tree will find which is server job and which is parallel job?
What are the partitioning techniques available in link partitioner?
What all are the different way to run a job?
How do you reject records in a transformer?
What is ibm datastage flow designer?