DB Software Laboratory - Leading supplier of Data Transformation and ETL software - Re:Do you have some example or “How To” for increm

Client Login

	Support Forum	Forum Threaded View Rules Help

Welcome, Guest
Please Login or Register. Lost Password?

Support Forum

Forum

Support

Do you have some example or “How To” for increment (1 viewing) (1) Guests

Favoured: 0

TOPIC: Do you have some example or “How To” for increment

Forum Tools

#546

pavel (User)

Fresh Boarder

Posts: 2

Do you have some example or “How To” for increment 3 Months, 3 Weeks ago	Karma: 0
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?

Report to moderator Logged

Logged

The administrator has disabled public write access.

#547

admin (Admin)

Admin

Posts: 31

Re:Do you have some example or “How To” for increment 3 Months, 3 Weeks ago	Karma: 0
What is your source and target data_base_ type? Can you create tables in source data_base_? Is you primary key numeric? Mike

Report to moderator Logged

Logged

The administrator has disabled public write access.

#549

pavel (User)

Fresh Boarder

Posts: 2

Re:Do you have some example or “How To” for increm 3 Months, 2 Weeks ago	Karma: 0
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.

Report to moderator Logged

Logged

The administrator has disabled public write access.

#550

admin (Admin)

Admin

Posts: 31

Re:Do you have some example or “How To” for increm 3 Months, 2 Weeks ago

Karma: 0

you can use

select * from yourtable where last_modified >=sysdate - 7

as a datasource
(provided that your source data_base_ 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

http://www.dbsoftlab.com/index.php/Documentation/Add-New-and-Update-existing-Records.html

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

When it is ready I will let you know

John

Report to moderator Logged

Logged

Last Edit: 2008/08/06 17:57 By admin.

The administrator has disabled public write access.