Question for anyone that might be able to help:

My objective is to eheck if a file (a source file) exists in a directory. If it does then, I'd like to call an application (Informatica ETL file...not necessary to know) to run a program which extracts data and loads it into multiple targets.

There are mutliple sources files to check for, and multiple applications to call, but the structure of the script should be the same for each source/target pair.

Hence would it be better to use 1 script which checks for all the files and runs a specific app depending on whether a specific file exists, or run a simply create 1 script template, and multiple scripts, 1 for each source/target pair?

The question also relates to job scheduling, schedule 1 script (which would be more advanced of a script considering all the looping or such), or schedule mutliple simpler scripts?

Any help is appreciated - novice script writer.