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...?

What are the different common services in datastage?

1296

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5129

---

Explain how a source file is populated?

1373

---

Which warehouse using in your datawarehouse

2192

---

How and where you used hash file?

1180

---

Explain the situation where you have applied SCD in your project?

2045

---

What is the difference between datastage and datastage tx?

1072

---

Is the value of staging variable stored temporarily or permanently?

1004

---

What are the repository tables in datastage?

1311

---

what is the use of surogate key in datastage

2312

---

What is the method of removing duplicates, without the remove duplicate stage?

1031

---

How to RD using transformer?

1431

---

Describe link sort?

1018

---

Why do we use exception activity in Datastage?

1321

---

how can we create rank using datastage?what is the meaning of rank?

8797

---