Ravisankar, The dynamic property needs to have a certain name, in general of the form initial.maxvalue.{max_value_column}. So if you have a max value column called last_updated, you will want to add a dynamic property called initial.maxvalue.last_updated, and you set the value to whatever you want the initial value to be. At that point the processor will only fetch rows where last_update > the value you specified.
Regards, Matt On Thu, Sep 8, 2016 at 8:31 AM, Ravisankar Mani <rrav...@gmail.com> wrote: > Hi All, > > I have used 'QueryDatabaseTable' processor in my workflow(incremental update > ETL process), initially , Its working properly once executed the job without > setiing max value column(first time only) and then setting the max value > columns(because the max value doesn't know processor) . But i need to set > the max value column initially , in this case , i saw the dynamic property > like 'Initial Max Value' in nifi guide. But i don't know how to set the > property in this processor. > Can you please help me to resolve the problem? > > > Regards, > Ravisankar