Support Questions
Find answers, ask questions, and share your expertise

Reference table lookup using NiFi

New Contributor

We are loading data from oracle table to Hive using NiFi. At the time of loading we will need to do some reference table lookup.
(e.g Customer data has Country_code = IN in Oracle, while loading Customer data in HDFS,
lookup using Country_code=In will be looked up in reference table and new column with value Country_detail = INDIA will be populated in Customer data).


Could you please guide me how it can be done?


Super Guru

Super Guru

Super Guru


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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.