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.

Answer / mandru naganji

open transformer stage and in stage variable tab right click and add sv and define datatype and length

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

---

What are some prerequisites for datastage?

0 Answers  

---

HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

1 Answers   HCL, IBM, Infosys,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

---

How to transfer file from one system to another system in UNIX?which command to be use?

4 Answers   Cap Gemini, TCS,

---

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,

---

Unix command to view the data in a dataset

2 Answers   IBM,

---

what is the difference between datasatge and datastage TX?

6 Answers  

---

What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,

---