Interested to Buy Any Domain ? << Click Here >> for more details...
how to define satge variables in transformer stage
- 2 Answers
- 22573 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
Define meta stage?
On which interface you will be working as a developer?
What are some prerequisites for datastage?
What is job control?
How to convert RGB Value to Hexadecimal values in datastage?
Differentiate between hash file and sequential file?
Explain entity, attribute and relationship in datastage?
Can you define merge?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Differentiate between data file and descriptor file?
what is the use of skid in reporting?
Demonstrate experience in maintaining quality process standards?
which r the connectors used in san?
How can you write parallel routines in datastage PX?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
