Hi Rahul, I'm working something similar and my first shoot was writing a Scriptedookup service to perform database lookups. Not sure if this is the recommended approach but it is working.
In case you want to give it a try you can take a look on Matt's articles "Scripting Cookbooks" to get a hang on NiFi scripting capabilities and then use Andy Lopresto groovy lookup as starting point: - https://community.hortonworks.com/articles/75032/executescript-cookbook-part-1.html - https://gist.github.com/alopresto/78eb1a2c2b878f75f61481269af38a9f - https://gist.github.com/alopresto/beb62a15c82c6d68528474085b1a9610 Best regards, Eric 2017-11-05 0:08 GMT-02:00 Malhotra, Rahul <rahul_malho...@intuit.com>: > Hi, > I am trying to enrich my data by looking up in a dimension table and > moving from one table to another. My warehouse is Vertica, is there a > recommended approach we can take? Or is it something we have to write as a > custom process? > > > Thanks, > > Rahul >