top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Informatica: Pass date value from one session to another session in the same workflow

+2 votes
858 views

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?

posted Nov 10, 2014 by Ronu

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Check the following thread it has identical problem
https://community.informatica.com/message/120773

1 Answer

+1 vote

Hi,

To equate the value of the mapping variable to the workflow variable is to be done in the "Pre-session variable assignment", and then in the next session property use "Post-session on success variable assignment" to equate the value back from the workflow variable value to the mapping variable. And this way, you pass-on the value of the mapping variable from one session to another, as per your requirement.

1.Have both the sessions in the same Workflow.
2. Assign the value you got from the mapping variable to the Workflow variable in Post session command task.
3. Assign the value from workflow variable back to mapping variable in mapping2/session2 in pre session command task.

This query returns the most recent run completion times,for workflows, along with folder name, and connection object names.
modify, or uncomment and modify or comment out the filter conditions to get the desired result.

answer Nov 11, 2014 by Shweta Singh
Hi Swetha, Thank for you reply. I am able to do this succesfully. But knldy helo me in same scenario...

Hi Experts,

 
My source EMP tables is below.

 
DEPARTMENT   DEPT_NO  JOIN_DATE    APPROVAL   STATUS

-----------  -------- -------------   -------  ------

COMPUTERS     1       10-JAN-2008      Y        RND
ARTS          2       30-NOV-1994      Y        RND

 
 
I have created a workflow like below.

                                

               $session1..TgtSuccessRows>=1              $$wf_department=computers

Wf1--> session1 --------------------------->decision_task-----------------------> Worklet1

                                                        ----------------------->Workelt2

                                                         $$Wf_department=arts

 
I have created two mapping varaibles $$JOIN_DATE and  $$DEPARTMENT.

 
I am passing $$JOIN_DATE value to worklet 1.

 
I wanted to executed worklet1 when $$DEPARTMENT=computers and wanted to executed worklet2 when $$DEPARTMENT=arts

 
I have created mapping variables, workflow varaibles and worklet variables and assigned them properly.

 
The above scenario is working only when 1 row is the source table.
But if it has two rows both (Computer and arts) it is executing only either worklet1 or workelt2

 
 
Could please help me the above scenario?
Similar Questions
0 votes

Suppose if we have duplicate records in a table temp_n. Now I want to pass unique values to t1 and duplicate values to t2 in single mapping? How can we achieve?

0 votes

I want to maintain audit information of each and every mapping in table which contains

workflow_name | start_time | end_time | source_success_rows | target_success_rows | error_record_count

i am able to do it using workflow variables assigning them with built-in session variables and then using the property of prevariableAssignment in session assigning the workflowflow variables to mapping variables of audit_session

It is working fine , But the issue is if i want to maintain audit for other mapping i have to create the whole process again . So is there any possibility of automating the process so that it does not require recreation of the whole thing again.

0 votes

I installed informatica PC8.6 on Windows XP and SQL Server 2008 R2 on another machine. How can I access this database from informatica pc.8.6. and is it possible to access?

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

How to tune the session, workflow for better performance, what are the things we consider for better performance?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...