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

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers   Wipro,

---

what is main difference between change capture and change apply stages

4 Answers   IBM,

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

---

how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,

---

how to cleansing data

6 Answers   Cap Gemini,

---

On which interface you will be working as a developer?

0 Answers  

---

how to load meta data

2 Answers   IBM,

---

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---