There might be a Content-Length available in the header of the binary document, but that can be hard to pull out and plumb through to where you would need it.
I think the DirectoryBrowser snap should report the file size, so it might be easier to pick it up from there before kicking off the FileReader.
Keep in mind that the pool size is an upper bound and it may not be reached, so you could set it something reasonable for your Snaplex size and pad it a bit.
Have you found that the increased pool size makes a difference in performance?
Hi, Appreciate your help !!
Do you have any link/reference where I can see how we can use Directory browser snap to get the file size. I don’t see anything in snap description.
Thanks!!
Why should it create an issue because then you only have the files with filed data to insert right ?
I can’t follow what your saying. You mean Succes after the last oracle insert? Or what do you mean?
Thank you @JensDeveloper. I think option 2 might work for me. Could you suggest how to do it, please?
Hi @amit.saroha ,
Below is the attachement of the pipeline. It’s a file reader with csv parser and router. Only use the csv parser and router.
Explanation CSV parer:
uncheck the checkbox ‘ignore empty stream’ - check containts headers.
Router explanation.
The first expression will return true if the input data is not empty ( it will output the input data to the first output view ), and the second expression will simply return true and will output the data on the second output view. With the First match option checked, only the first expression that returns true will be evaluated to the output even if there are more expressions that return true.
CsvFile_Validation_V1.0_2022_07_07.slp (5.1 KB)
Regards
Jens
