how to define satge variables in transformer stage
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / mandru naganji
open transformer stage and in stage variable tab right click and add sv and define datatype and length
Is This Answer Correct ? | 0 Yes | 0 No |
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
difference between server shared container and parallel shared container
where we use config file as parameter ?
Is possible to create skid in dim,fact tables?
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
how do u reduce warnings
How to create user defined environment varibale(parameter)?
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)
What is lookup table?
What is ibm datastage?
What is a datastage job?