Replication problems!

Moderator: NorbertKrupa

Post Reply
adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Replication problems!

Post by adrian.oprea » Fri Nov 30, 2012 7:00 pm

Hy everybody ,

I have a Oracle to Vertica replication environment mounted on a 30 min trickle load schedule and i am dealing with some programming issues.
Imagine this scenario :
In a 30 min period i have new inserted data and as well i have updates made on my source tables.
How can i insert new data and update updated data in Vertica as well ?

My plan:
- add a (times-tamp)column on the source tables and get all the data that was altered or inserted upon that time-stamp period(every 30 min), so far so god - i got all that is new , but now how can i dump this in Vertica ?
Any previous experience with this kind of layout ?
THX
trying so hard !!!

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: Replication problems!

Post by jpcavanaugh » Fri Nov 30, 2012 9:17 pm

If the table has a PK, look into ANSI Merge

Post Reply

Return to “Vertica Migration”