top button
Flag Notify
Site Registration

Email Task in Informatica

+1 vote

Is there a way of sending a text version of your changes to a mapping on an email task? I have mapping that would make approximately 10 changes to a table. As this mapping finishes, I want to use the email task to send the recipient a list of changes that were made.

Is that possible? (If not, is the next best solution outputting these changes to a .txt or flat file, and sending that to the recipient?) Either way, can someone provide detailed instructions on how to accomplish this task? I just want to know the changes made in an email form.

Thank you

posted Aug 18, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Create a mapping to load the results of this query into a flat file or an Excel spreadsheet. Then email the target file as an attachment.

answer Aug 19, 2014 by Shweta Singh
Similar Questions
+1 vote

My script ran successfully in Unix but not in a command task of an Informatica workflow. The permissions are fine, and the parameter file and variables have been declared in the workflow. Why is this happening?

0 votes

I tried a simple

if [ 1 == 1 ]; then echo "Hi"; fi >>/projects/ods/Chk.txt
included in the command task but it fails with error code 512....

what am I missing here?

+2 votes

Is there any environment variable which holds the value of task ran ?

+1 vote

I'm trying to get my Informatica workflow to fail a session if it selected 0 source records. I have come up with the following script to run as the Post-Session Success Command:

if [ $PM{Source Qualifier Name}@numAppliedRows == 0 ]
exit 2
exit 0

where {Source Qualifier Name} is the name of my source qualifier. When I look at the session log it looks as I would expect where the $PM{Source Qualifier Name}@numAppliedRows is replaced by the number of rows my source qualifier selected but it is still causing the session to fail even when this number is != 0. The session log gives me the following error message:

sh: 0403-057 Syntax error at line 1 : 'if' is not matched.

Any help would be appreciated.

+1 vote

Is it possible to get the name of previous task from current task in in particular workflow in informatica?
Is there any environment variable which holds the value of task ran?