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
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 |
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 |
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
what are the deliverables?in your project?
How do you implement scheduling in Informatica?
Why we require dwh in particular projects?
State the differences between sql override and lookup override?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
how may sources can be used in a mapping at a time?(limit)
difference between stop and abort
Enlist some properties of sessions.
How union transformation is active ?
Define the various join types of joiner transformation?
During the running session, output files are created by informatica server. Enlist few of them.