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 .

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

---

sed,awk,head

0 Answers   CTS,

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

---

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers   Cognizant, IBM, TCS, Virtusa,

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---

How complex jobs are implemented in datstage to improve performance?

0 Answers  

---

what is operator combinality in datastage?

1 Answers   TCS,

---

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

6 Answers   IBM,

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

---