I have an ODI Load Plan that I only want to execute the remaining steps past the very first step if a specific .TXT file is found in a specific FTP location.
Basically, there's a Unix shell script that runs as one of the first steps in the Load Plan. That Unix shell script determines if there are new .ZIP files present in a URL, downloads those new .ZIP files, and create an empty .TXT file in a specific FTP directory to sit there and serve as an indicator that we need to continue going forward executing the remaining steps within the Load Plan to actually load data from the various .CSV files present in the numerous .ZIP files that were just downloaded.
I'd like to determine if this empty .TXT file is present, and if it is, continue moving forward with execution of the remaining 9-9 Loan Plan steps to actually do the data load. If the empty .TXT file is NOT present, then I want to conditionally determine to NOT continue forward with the execution of the additional 8-9 steps since new .ZIP files were not found/downloaded from the URL.
I'm trying to figure out what components to use to accomplish this desired conditional logic. I'm reading some info. on ODIFTP and ODIFTPGet but I haven't found anything concrete on this.
Many thanks for any pointing in the right direction on this.