Answer Posted / shar

ok lets us say after getting result like
a,8000
b,9000
c,9999
acc to nandhini using dummy key would give me
a,8000,1
b,9000,1
c,9999,1
then use rem duplicate stage then we get 9999 as output after we assign retain duplicates=last for dummykey col.
what if
i have diff data and got output like below after aggreagation
a,9000
b,18000
c,10000
now what...?

Describe the main features of datastage?

1125

---

What is datastage engine?

1225

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

969

---

What are the components of ascential data stage?

1241

---

What a datastage macro?

1101

---

How a routine is called in datastage job?

1163

---

What is the process of killing a job in datastage?

1067

---

Differentiate between datastage and datastage tx?

1112

---

How many types of hash files are there?

1233

---

How to read the length of word in unix?

1433

---

how to abort the job its matain duplicates?

2623

---

What is difference between server jobs & parallel jobs?

1089

---

What is the purpose of pivot stage?

1231

---

Which algorithm you used for your hashfile?

1232

---

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

823

---