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 can u write exception handling in seq file????

2 Answers   IBM,

---

How can we do null handling in sequential files

3 Answers   Reliance,

---

what is datastage job Monitoring

6 Answers   CTS,

---

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

What is difference between join, merge and lookup stage?

0 Answers  

---

How to manage date conversion in Datastage?

0 Answers  

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

Hi All, Could you please let me know whether Datastage server and px supports oredb? OREDB:It's a Oracle Retail Embedded Database.Previousely It was called as Acumate data base. It's a multidimensional database. Please help me on this issue ASAP. Thanks in advance Ashok

1 Answers   Accenture,

---

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  

---

How to add zero "0" before record in a field?

4 Answers  

---

why do we need a datawarehouse when we have databases to store data?

1 Answers   L&T,

---