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?
... View more