top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Is it possible to get the name of previous task from current task in in particular workflow in informatica?

+2 votes
513 views

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

posted Mar 18, 2014 by Madhavi Kumari

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

1 Answer

+1 vote
  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.
    Informatica

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

answer Mar 18, 2014 by Shweta Singh
Similar Questions
+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?

0 votes

Can anyone tell me how to find the list of mapping and the workflow that are using a particular table say X either as a source or target table?

0 votes

For cleaning up unused IPC-Sources I need a Repository Query for getting Workflow, Session, Mapping and Source/Target of Mapping.I have startet by joining REP_LOAD_SESSIONS and REP_TBL_MAPPING on mapping_id but only a fraction of mappings seem to be present in the joined output. I can't find the right tables to join to get the job done. Any help will be greatly appreciated!

+2 votes

I have two sessions I a workflow like below

workflow1->session1->session2

I have a join_date column in a table in Mapping1 , in session1. I want to pick this join_date value and pass to mpping2/session2

If join date value changes in the table in session1 then the same value should pick and pass to session2. I will use this date value in a query in session2 .

Please suggest how to achieve this?

...