Interested to Buy Any Domain ? << Click Here >> for more details...
how to define satge variables in transformer stage
- 2 Answers
- 22696 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 do u catch bad rows from OCI stage? And what CLI stands for?
What are the functionalities of link collector?
Explain how a source file is populated?
What is active and passive stage?
What is the purpose of pivot stage and types of containers in datastage
how many rows sorted in sort stage by default in server jobs
What are stage variables, derivations and constants?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are some different alternative commands associated with "dsjob"?
How to implement complex jobs in data stage?
Why do you need stage variables?
Describe the architecture of datastage?
Where the datastage stored his repository?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What is the use of datastage designer?
