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

If we are using flat file in our loading, and flat file name change daily so how we handle this without changing file name manually daily?
for example: like file name is changing depend on date so what should I do? pls help…

Showing Answers 1 - 5 of 5 Answers


  • Nov 20th, 2011

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

  Was this answer useful?  Yes


  • Nov 30th, 2011

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.

  Was this answer useful?  Yes


  • Dec 7th, 2011

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.


  Was this answer useful?  Yes


  • Dec 28th, 2011

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.....

  Was this answer useful?  Yes


  • Jan 24th, 2012

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

put a shell script at the pre-session command.

The content of is as:

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.


Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions