Is there some way to distinguish when we have an input empty file in the source or the file is missing? (sftp protocol with "flat file" data source)
From our POV, the behaviour should be different:
We are expecting to receive a delta file with "yesterday" changes, and if no changes were made (the file is empty), we will generate an empty file.
But if the input file is missing, we do not want to generate the file, it is an upstream failure and we do not want to send a wrong snapshot to our downstreams.