Thanks Eric. This helps.
Rahul Malhotra Group Development Manager – Data Labs | Consumer Tax Group | Intuit Inc. | w: (858) 215-7150 | c: (760) 889-7206 https://bluejeans.com/7608897206 From: <e...@craftti.com.br> on behalf of Eric Chaves <e...@uolet.com> Reply-To: "users@nifi.apache.org" <users@nifi.apache.org> Date: Sunday, November 5, 2017 at 3:05 PM To: "users@nifi.apache.org" <users@nifi.apache.org> Subject: Re: Enrichment 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<mailto: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