What is workflow variable? When we use workflow variable? Can any one explain me with one example???
Answer Posted / 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 |
Post New Answer View All Answers
What is target load order?
How to handle decimal places while importing a flatfile into informatica?
What is exclusive and normal mode for repository services?
Repository user profiles
What are the advantages of using informatica as an etl tool over teradata?
What are the types of schemas we have in data warehouse and what are the difference between them?
how many types of dimensions are available in informatica?
is it possible to index the data in cache of lkp transformation ?
Explain the different kinds of facts.
Mention a few design and development best practices for informatica?
how to load rows into fact table in data warehouse
Write the unconnected lookup syntax?
What is the surrogate key?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are different types of transformations available in informatica?