How to specify Source flat file name in mmddyyyy format in Informatica Session.

The source file is FTP'ed daily and it is appended with mmddyyyy. How do i specify the file name in the Source connection present in Informatica session
  • Interview Candidate
  • 3
  • 2484

Showing Answers 1 - 3 of 3 Answers

Mamatha

  • Oct 24th, 2007
 

I hope it will work. You have to give this command in the pre session command

/_`date "+%d%h%Y" | awk '{print toupper($0)}'`.txt

Thanks
Mamatha

  Was this answer useful?  Yes

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