top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: Get the name of previous task from current task?

+1 vote
670 views

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?

posted May 27, 2014 by Pooja Bhanout

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

2 Answers

0 votes

1.Declare a workflow variable (e.g. $$LAST_SESSION).

2.Use the Post-session variable assignment component (on success or on failure or both) to store a name of executed session
enter image description here

3.Use the $$LAST_SESSION value in the reusable alert task.

answer May 28, 2014 by Shweta Singh
0 votes

Built-in variable ($PMSessionName) holds the name of the session.

Create a Workflow Variable and through Post-Session Variable Assignment Component assign $PMSessionName value to Workflow Variable for further use.

answer May 30, 2014 by Shatark Bajpai
Similar Questions
+2 votes

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

+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?

+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 ]
then
exit 2
else
exit 0
fi

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.

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?

+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

...