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?
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