RE: [EXT] CDC like updates on Nifi

2017-12-06 Thread Peter Wicks (pwicks)
: users@nifi.apache.org Subject: Re: [EXT] CDC like updates on Nifi On Tue, Dec 5, 2017 at 11:55 PM, Peter Wicks (pwicks) mailto:pwi...@micron.com>> wrote: Alberto, Hello Peter, Thanks for your answer. Since it sounds like you have control over the structure of the tables, this sho

Re: [EXT] CDC like updates on Nifi

2017-12-06 Thread Alberto Bengoa
On Tue, Dec 5, 2017 at 11:55 PM, Peter Wicks (pwicks) wrote: > Alberto, > Hello Peter, Thanks for your answer. > > > Since it sounds like you have control over the structure of the tables, > this should be doable. > > > > If you have a changelog table for each table this will probably be easier

RE: [EXT] CDC like updates on Nifi

2017-12-05 Thread Peter Wicks (pwicks)
Alberto, Since it sounds like you have control over the structure of the tables, this should be doable. If you have a changelog table for each table this will probably be easier, and in your changelog table you’ll need to make sure you have a good transaction timestamp column and a change type