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 |
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
What are two types of processes that informatica runs the session?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
What is Java Transformation? what are the uses of it?
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
Where is the cache stored in informatica?
Which version configuration tool used in ur project?
Differentiate between a repository server and a powerhouse?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
where does the default group roew in a router is stored what is the default size of memory in router
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.