Informatica: if flat file name varies day by day ...

You can use Informatica File List option to get the dynamic file names. You also need to use shell scripts to get this done.

In Session level, we can select Source File Type as Indirect . When you select Indirect, the Integration Service finds the file list and reads each listed file when it runs the session. So inside the file list we can mention the file name that is changing frequently.

You create a shell script to load all the file names in a list file in the server location and through informatica as sumitha said, you can use the indirect file reading method to process the dynamic input files.

Thanks,
Susee

You can use Informatica File List option in target to get the dynamic file names along with the transaction control transformation so that you can create dynamic filenames based on some transaction properties.....

Use the indirect filelist option at informatica session.
say the filelist name is daily_file.txt

put a shell script daily_filename.sh at the pre-session command.

The content of daily_filename.sh is as:

filename_stagnant=ABC
filename_new=$filename_stagnant`TZ=CST+24 date +%Y%m%d`
echo $filename_new >daily_file.txt

__________________

You can modify the filename_stagnant and date formatting as per your requirement or project conventions.

Regards,
Charu.