top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica environment variables?

+1 vote
435 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 Sep 12, 2014 by Amit Sharma

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

1 Answer

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 Sep 16, 2014 by Shweta Singh
Similar Questions
+3 votes
Specifying Source file name using parameter variables in informatica 9?

I have a mapping like
SA-->SQ--->EXPR--->TGT

The source will be of the same structure and the tartget also.
There are a bunch of files(with the same structure) which will go through this mapping .
So i want to use a parameter file through which i will give the file names for every run manually.

How to use the param file in session for Source filename attribute
Please suggest..

+2 votes
Getting error while importing workflow into QA environment from DEV

I am getting below error while I am trying to import workflow from DEV environment to QA. I was able to import once successful but someone deleted that and now I am trying it again, then it is giving error:

  04/04/2012 16:56:46 ** Importing Mapping: m_BTTC_Load_T3_T1 ...
     : Could not find Transformation definition for: TEMP_BTTC_TABLE_1
     ** Failed to Import: m_BTTC_Load_T3_T1

I tried importing it from Repository Manager. 1st time it was successful exported from Dev and then I imported in QA. But someone deleted whole folder from QA, now I am tring to do it again, but getting above error.

+1 vote
How do mapping parameter and mapping variables differ?

How do mapping parameter and mapping variables differ?

+3 votes
Source Qualifier SQL Override Error with Mapping Variables

I am using a mapping variable of date/time data-type and aggregation MAX In Source Qualifier SQL Override i am giving select col1,col2 from tbl where col1>$$dt

(col1 is also date data type)

When i am validating the query it is giving Invalid Query and error was

 [Microsoft][ODBC driver for Oracle][Oracle]ORA-00933 : SQL command not properly ended

I have also done extraction of characters like select col1,col2 from tbl where to_char(col1,'DD-MM-YY')>to_char($$dt,'DD-MM-YY') but still the same same

I am not getting what the error is and the same thing if i am trying for number column the it is validating fine and performing incremental extract also.

Any suggestions regarding the same will be helpful

...