how to define satge variables in transformer stage
- 2 Answers
- 21947 Views
- I also Faced
- E-Mail Answers
Answer Posted / dilip anand k
The stage variables are those variables that can be used
and declared on our own inside the transformer stage. These
are accessible only from the transformer stage in which
they are declared.
Any Stage variables we declare are shown in a table in the
right pane of the links area.
Defining the Stage Variable:
Select Insert New Stage variable from the stage variable
shortcut menu. A New variable is added in the table showing
the stage variables in the links area. The default name
given would be StageVar with the default datatype Varchar
(255). These properties can be edited using the Transformer
stage properties dialog box.
To Open the Transformer Stage Properties box
*Click on the stage properties button on the transformer
toolbar.
*Select the stage properties from the shortcut menu
*Select Stage variable properties from the stage variable
shortcut menu
The Properties box contains the Variable Name, Initial
Value, SQL data type, Precision, Scaling and Description
(optional).
Edit the variable as required and Click OK.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
How to reverse the string using SQL?
How can we improve the performance in datastage?
Could anyone give brief explanation bout datastage admin
What are the types of jobs we have in datastage?
How to reverse the string using unix?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What can we do with datastage director?
How a server job can be converted to a parallel job?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
how to delete one row in target dataset
How rejected rows are managed in datastage?
How one source columns or rows to be loaded in to two different tables?
Explain ibm infosphere information server and highlight its main features?
What are some prerequisites for datastage?
