Hi, I developing a nifi processor for netezza. As per by experience the best way to load data to netezza is using netezza JDBC external table.
I want to run below command to load a file within NiFi processor. insert into MYTABLE select * FROM EXTERNAL '<local file system filename>' USING (<JDBC Options>) ; My question is which file to usefor <local file system filename> ? - Is it the flow files ? If yes then how can I get full path of a flowfile ? - or can I directly load the file in a spool directory ? Thanks for your help in advance. -Obaid
