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 .

what is hash file

2 Answers   CTS, 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  

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  

---

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

---

sed,awk,head

0 Answers   CTS,

---

What is mapping?

3 Answers  

---

WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,

---

How to perform incremental load in datastage?

0 Answers  

---

Is it possible to query a hash file?

0 Answers   IBM,

---

What is a merge?

0 Answers  

---

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 Answers  

---