Hi This is Vijay,

How can your remove the duplicates in sequential File?

Answer Posted / charan

hi this is charan
in sequential file there is no distinct keyword.But we use sequential file properties reject mode=output and then use remove duplicate stage based on key column(here we can't store the duplicate records).

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1638


what is repositery?

1302


Why fact table is in normal form?

683


How you can fix the truncated data error in datastage?

1210


What is a ds designer?

645






Enlist various types of routines in datastage.

648


How do you import and export data into datastage?

707


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

592


I have a few records just I want to store data in to targets cycling way how?

1907


Define Job control?

681


How do you register plug-ins?

606


What is the command line function to import and export the ds jobs?

686


Explain connectivity between datastage with datasources?

605


What is datastage?

652


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

640