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
Replication problems!
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 163
- Joined: Tue Jun 19, 2012 2:44 pm
- Location: Rio de Janeiro
- Contact:
Replication problems!
trying so hard !!!
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: Replication problems!
If the table has a PK, look into ANSI Merge