Is it possible to skip a given number of records in the source dataset,
not just one at a time?

We are trying to replicate some old data in dbf tables. The only
changes made to these tables from the source application are the
appending of records, but there is no clear primary key. I want to be
able to jump past all the older records without having to scroll
through them.

Thanks,
Aaron

How are you going to identify old records then?

Can you not do the identification in the Source query that selects the
data?



Allan

"Aaron" <amilner (AT) racltd (DOT) com> wrote

If there's an identity column say where id_col > 93843 or whatever the
id is of the last "old record" ... Alternatively add a
timestamp/datetime to the source table and pull those records following
the point in time you made changes to the application.

If you're not going to use the records you probably don't want to pull
them (IOs, network traffic, ... )