how to define satge variables in transformer stage
- 2 Answers
- 21867 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 is the custome stage in datastage? how can we impliment that one? plz tell me
What are the difference types of stages?
How to Remove Duplicate using SQL?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is the purpose of pivot stage and types of containers in datastage
how to abort the job its matain duplicates?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Differentiate between odbc and drs stage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is the use of datastage director?
Explain ibm infosphere information server and highlight its main features?
Which algorithm you used for your hashfile?
How to clean the datastage repository?
