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?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Reference table lookup using NiFi

Super Guru
2 REPLIES 2

Re: Reference table lookup using NiFi

Super Guru

Re: Reference table lookup using NiFi

Super Guru

https://community.cloudera.com/t5/Community-Articles/ETL-With-Lookups-with-Apache-HBase-and-Apache-N...

 

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