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.

What are the types of containers and how to create them?

1021

---

What is the process of killing a job in datastage?

1067

---

How do y read Sequential file from job control?

16071

---

Terminate Activity

1335

---

Why do we use link partitioner and link collector in datastage?

1185

---

Highlight the main features of datastage?

1214

---

What are the various kinds of containers available in datastage?

1100

---

Difference between sequential file and data set?

1259

---

What is ds designer?

1160

---

what is ds administrator used for?

1215

---

Explain entity, attribute and relationship in datastage?

1153

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2330

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1216

---

How to reverse the string using unix?

3589

---

what is the use of skid in reporting?

2426

---