ETL and Data Integration tools - Modern ETL software for everyone

We have a table we have to incremental import from time to time.
We have last_modification_date field in those table. I don't like we to import already imported rows. What is the easiest way to solve this issue with Visual Import?

What is your source and target database type?
Can you create tables in source database?
Is you primary key numeric?

Mike

Source: ODBC
Target: Oracle
We don't have yet writing rights for source db so we can't create there any tables.
Our primary key isn't numeric but we have last_modified field.

you can use

select * from yourtable where last_modified >=sysdate - 7

as a datasource
(provided that your source database is Oracle and you want to load data changed during last 7 days)

Than set transformation type to Add new and update old records

as described here

www.dbsoftlab.com/Documentation/Add-New-...xisting-Records.html

I am writing an article which describes the ways of synchronizing data between different databases.

When it is ready I will let you know

John