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 |
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
What is union transformation?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
how to remove staging area
What is the benefit of session partitioning?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
what are testing in a mapping level please give brif eplanation
What are the different ways to implement parallel processing in informatica?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What is meant by lookup transformation?