I am new to nifi data tool. Below is my requirement.
I have csv file with below content.
empid,empname,salary
1,'John',1000
2,'Alex',2000
3,'',3000
4,'',5000
I have to process only those records where empname is not null, to achieve this
i am using queryrecord processor and i am getting below records which is fine.
empid,empname,salary
1,'John',1000
2,'Alex',2000
Before inserting above values in oracle database, the first below four fields have data like below.
record_id : seq_file_id.nextval||lpad(rownum,16,0)
file_id : seq_file_id.nextval
source_id : 20
vendor_id : 30
structure of table(emp)
=======================
RECORD_ID NUMBER
FILE_ID NUMBER
SOURCE_ID NUMBER
VENDOR_ID NUMBER
EMPID VARCHAR2(200)
EMPNAME VARCHAR2(100)
SALARY VARCHAR2(200)
how should i insert values using Putdatabaserecord Processor ? Any help will be much appreciated.
