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


Please Help Members By Posting Answers For Below Questions

What is a filter transformation and why it is an active one?

562


What is a code page?

716


Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

656


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1323


Why update strategy and union transformations are active? Explain with examples.

714






What is meant by active and passive transformation?

587


How do you take back up of repository?

723


what is the Default Source Option For Update Strategy Transformation?

756


What do you mean by filter transformation?

555


Explain pushdown optimization and types in informatica

668


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5256


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1510


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1658


What is Session and Batches?

665


What is the use of source qualifier?

672