What is workflow variable? When we use workflow variable? Can any one explain me with one example???

Answers were Sorted based on User's Feedback



What is workflow variable? When we use workflow variable? Can any one explain me with one example???..

Answer / anvesh

A variable which is created in workfow manager is called workflow variable. This is used for many tasks, for example.. I created a mapping level variable, which is not assigned with initial value. So by using this Workflow variable we can assign value to the mapping variable.

For this we have to use assignment task.

WF-> Assignment task -> Session(non reusable)

First create a variable in workflow manager, go to workflow-> edit -> add a port. In this assign a name to the variable. Now create assignment task in workflow manager. In this create a new port. Now name it as the name given to mapping level variable and assign a value to this variable.

Now go to session properties -> command, then give $$ mapping variable = $$ Session variable.

this will wrk... if not pls reply me...

Is This Answer Correct ?    8 Yes 3 No

What is workflow variable? When we use workflow variable? Can any one explain me with one example???..

Answer / guest

I used workflow variable to update the session status in
database table.

take assignment task for capturing session status by using
workflow variable if you want in depth pls let me know..

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,


What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

1 Answers   CTS,


What are pre and post-session shell commands?

0 Answers  


in which situations do u go for starflake schema ?

6 Answers   TCS,


what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,






explain abt union t/r?

1 Answers   IBM,


If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,


What is rank transform?

0 Answers  


how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,


why we are using surogate key in real time give me explanation

2 Answers   TCS,


What is xml source qualifier transformation in informatica?

0 Answers  


What is an active transformation?

0 Answers   Informatica,


Categories