We currently have a TIDAL Job where a File Event monitor the existence of a certain file lets call it FileExists.txt.
When the dependency is satisfied, we kick off an Informatica Job. Works well.
Now the ask is to try to fit in a Logic that checks the size of the FileExists.txt file and (a) send and email out if its an empty file (0 KB) (b) proceed as usual with the Informatica Job.
Any suggestion as to how this can be achieved?