i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

---

How do you schedule or monitoring the job?

0 Answers  

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

How do you load dimension data and fact data? Which is first

2 Answers  

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 Answers  

---

What are routines in datastage? Enlist various types of routines.

0 Answers  

---

Define Job control?

0 Answers  

---

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

1 Answers   HSBC, NTT Data,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---