My source files are in sftp location and I use FileReader snap to retrieve the data from that location. However, I need only specific columns from those files. FileReader reads all the columns and CSV parser generates all the data in that file. Those specific columns are already in the database. How to compare and write the data to the database?
Thanks
