Replication problems!
Posted: 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
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