How to send email from Informatica with Post-session success/failure

Hi All,

I need to put the value of a col (request-id) in the text of the body of the post-session success/failure email which I have to send in Informatica. How to achieve this? We cannot, I guess, use a Parameter File for this as it would take the same value every time and put it in the email. I want to use the value of request-id which will be different on each session run and capture that value in some parameter/variable and use that in session in the post-session email.

Kindly suggest a way to do this.

Regards,
Sree


  • Interview Candidate
  • 8
  • 26529

Showing Answers 1 - 8 of 8 Answers

Motilal

  • Jul 10th, 2006
 

In the workflow, create one target file populating it with the required column.

Use the file to mail

  Was this answer useful?  Yes

N SRIRAM K

  • Jun 25th, 2007
 

Great, requirement .. I have never even read it.
How would you a column into mail.
Through email you can send a message or you can send no. of rows rej/accepted and all other stuff. Even you can send target file/log file through attaching to the mail.
You can't add a column into it.
Is that column contain single values...I think no...it may have more than one value so it is typical to do this.
But you can do this with Command Task by executing the UNIX script.
Further queries ask me: sriram_kumar at oneindia dot in

kalyani.y

  • Oct 9th, 2012
 

Create the EMAIL Task, in Properties Tab
1. EMAIL USER NAME : give the email id required
2. Subject as %w -- %e
3. Email Text as
%g
Session Start time : %b
Session completion Time : %c
Total Records Loaded : %l
Total Records Rejected %r

With the above you will get a session log file as attachment and using that file as source capture the detail you want and load it into table you want

  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