Informatica: Text file location and its data check on FTP server

Question

How to check using informatica whether a flat file exists at a location at FTP server also to check if it contains some data?

Answer 1

One solution is to create Windows or Unix shell script on the Informatica server that checks for the existence of the file. Something like this:

#!/usr/bin/ksh

if [ ! -f /Filelocation/INPUT_FILENAME.txt]
  then
    echo "Source not found"  
    exit 1
  else
       echo "Source present"     
          exit 0
  fi
done
exit 1

Create a command session in Workflow that runs this script.