Interested to Buy Any Domain ? << Click Here >> for more details...
how to define satge variables in transformer stage
- 2 Answers
- 22530 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
What are the functionalities of link partitioner?
How many Key we can define in remove duplicate stage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the roundrobin collector?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Difference between server jobs & parallel jobs?
Why do we use exception activity in Datastage?
Why do you need stage variables?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the difference between informatica and datastage?
What all are the different way to run a job?
What is a folder? Difference types of stages?
