https://community.cloudera.com/t5/Community-Articles/ETL-With-Lookups-with-Apache-HBase-and-Apache-NiFi/ta-p/248243   That is an HBase example, just use a different one.   We also teach how to do the lookup / update record processors in our CDF Workshop roadshow ... View more