@Gowthaman V check out this gist which has an example flow to properly use the distributed cache - https://gist.github.com/ijokarumawak/8ba9a2a1b224603f877e960a942a6f2b Also this might help you - https://stackoverflow.com/questions/44590296/how-does-one-setup-a-distributed-map-cache-for-nifi ... View more

Nifi is not the best tool to do table joins. It will be able to do some transformations, but the heavy lifting should be done with spark or storm (if real time is needed). Have a look at this thread: https://community.hortonworks.com/questions/64667/joining-tables-within-nifi.html ... View more