Re: Re: Re: QueryDatabaseTable - Deleted Records

2017-09-18 Thread Matt Burgess
<apere...@gmail.com> > An: users@nifi.apache.org > Betreff: Re: Re: QueryDatabaseTable - Deleted Records > > As an interesting architectural approach we took eons ago, before NiFi, was > to take daily snapshots of a full table. Every row would then be > hashed/digested or in any other way

Aw: Re: Re: QueryDatabaseTable - Deleted Records

2017-09-18 Thread Uwe Geercken
.   Rgds,   Uwe       Gesendet: Samstag, 16. September 2017 um 13:52 Uhr Von: "Andrew Grande" <apere...@gmail.com> An: users@nifi.apache.org Betreff: Re: Re: QueryDatabaseTable - Deleted Records As an interesting architectural approach we took eons ago, before NiFi, w

Re: Re: QueryDatabaseTable - Deleted Records

2017-09-16 Thread Andrew Grande
As an interesting architectural approach we took eons ago, before NiFi, was to take daily snapshots of a full table. Every row would then be hashed/digested or in any other way uniquely identified and 2 datasets would be crossed and compared to find inserts/deletes/updates. It was involved, but