Informatica emails on session completion

Over the past year and a half, I have been learing Informatica in order to integration data between several applications. I have learned and created a few configuration settings that I use on all of my workflows.

The first of these is email notification on all sessions. I also include a final workflow email in my more complicated workflows, but this post only deals with the session emails.

I use re-usable email tasks in all of my workflow sessions so that I receive a status email when the session is run. Some admins do not want to receive multiple emails, but I like to see the emails come through as the sessions are compeleted, and I also prefer to get the row count information to verify the correct volumes of data are being processed.

Setup Steps
First, setup a re-usable email task for success emails and another re-usable email task for failure emails.

Success Email Tas Configuration:
Email User Name – set to an admin group
Email Subject – SUCCESS – Workflow Session %s
Email Text -
Session – %s
Mapping – %m
Repo – %d

%b
%i
%c

%t

%l
%r

The email text displays the session name, mapping name, repository name (dev, tqa, prod) and then displays information on the running of the session. This includes the start and end time of the session, source row counts, target row counts, and finally total rows loaded and total rows rejected.

I also have a failure email task setup with the only difference being the subject which starts with FAILURE instead of SUCCESS.

Second, in each session, go to the Components tab and setup the On Success E-Mail and On Failure E-Mail values to use the appropriate re-usable email task.

Now, each session will send a status email upon completion.

Here is a sample of the email that is generated:

Session – s_m_MyApp_DataFeedABC
Mapping – m_MyApp_DataFeed [version 4]
Repo – REPO_PRD

Start Time: Wed Dec 10 16:41:33 2008
Elapsed time: 0:03:55 (h:m:s)
Completion Time: Wed Dec 10 16:45:28 2008

SOURCE
Rows Rows Data
Loaded Rejected Throughput Table Name
(bytes/sec)
———- ———- ———- —————-
Status
—————————————————————-
1080 0 1080 SQ_Shortcut_to_CSV_Daily
No errors encountered.
—————————————————————–
—————————————————————–
TARGET
Rows Rows Data
Loaded Rejected Throughput Table Name
(bytes/sec)
———- ———- ———- —————-
Status
——————————————————————————–
158 0 11 MyTable_Insert
No errors encountered.
485 0 33 MyTable_Update
No errors encountered.
144 0 36 MyTable_LOADERROR_Insert
No errors encountered.
293 0 17 MyTable_LOADERROR_Update
No errors encountered.

Total Rows Loaded = 1080
Total Rows Rejected = 0

Now sit back and enjoy the barage of emails