Answer / srinivas

Take seq->Agg->seq
IN agg select grouping Key Group=Name
IN Aggregations select Column for Calculation = Salery
Sub properties - Select Minimum Value output - Minimum salery
Sum of weights output - count

For second output

seq-agg-xsfm-seq
group on Name and count rows , In xsfm apply Looping .

How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  

---

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

0 Answers   Wipro,

---

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

1 Answers   TCS,

---

My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.

6 Answers   Wipro,

---

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

---

Explain the ChangeApply stage?

11 Answers  

---

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

0 Answers  

---

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

17 Answers   IBM, TCS,

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

in oracle target stage when we use load option and when we use upsert option?

0 Answers  

---

is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,

---