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 |
Difference between server jobs & parallel jobs?
What is the method of removing duplicates, without the remove duplicate stage?
how to remove duplicates in transformer stage by using stage variables?one example?
1)Source file contains one record, I want 100 records in target file.
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
can we see the data in fixed width file? how can u change the datatype of fixed width files?
What are the stages in datastage?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
What is the purpose of pivot stage?
How do you load dimension data and fact data? Which is first
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?