INFORMATICA: How to send file as an attachment to business.

May 19, 2011 9:55 am3 commentsViews: 667
You are being asked to design an email sending process by using informatica email task where your application is able to send email communication in case of some records got rejected by INFORMATICA ETL, its being expected that business user should also have visibility to those records instead of just having an application process failure notification.
Solution : This also can be achieved by (g , a) Email Variables.
(%g)              - To attach session log.
(%a<>)        - To attach file, Absolute path need to be given <>.

Code Sample to be written in Email Task

Please find attached log for further investigation.
%g\n

Screen shot -

 

-

Related Topics:

  1. How to display records loaded to target in INFORMATICA email task
  2. Informatica parameter file creation and usage

3 Comments

  • I’m impressed, I need to say. Really rarely do I encounter a weblog that’s each educative and entertaining, and let me inform you, you may have hit the nail on the head. Your thought is outstanding; the difficulty is something that not enough persons are speaking intelligently about. I’m very glad that I came across this in my search for one thing relating to this.

  • Archie Penney

    Wonderful Job on the Site!

  • This is really good. I really like the way you represent the things.It makes much easier to understand.

Leave a Reply



nine + 3 =