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 - 15 of 15 Answers

Ashish

  • 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

Sumithav29

  • 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

Suseendiran

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

Thanks,
Susee

  Was this answer useful?  Yes

SHIV

  • 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

Charu

  • Jan 24th, 2012
 

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.

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