Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color
Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Do you have some example or “How To” for increment (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: Do you have some example or “How To” for increment
#546
pavel (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
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
graph
User Online Now Click here to see the profile of this user
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
graphgraph
User Offline Click here to see the profile of this user
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
graph
User Online Now Click here to see the profile of this user
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.
Go to top Post Reply
Powered by FireBoard

What our customers say

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time.

We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,

RBS