Answer Posted / subhash

According his logic: from aggregator stage: the output is
this: 251,2
456,2
951,1
985,1
the main data is:
251
251
456
456
951
985

If you join these two links then the output will be:
251,2
251,2
456,2
456,2
951,1
985,1

Then your are specifying that count=1 then you get the
unique records. means YOU get: 951,985


in another link count<>1 means YOU get: 251,
251,
456,
456

this is our desired out put, our out put.
the logic explained by Shiva is correct.

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)

917

---

What is the roundrobin collector?

1095

---

What is the difference between operational data stage (ods) and data warehouse?

1238

---

table actions available in oracle connector?

1605

---

Terminate Activity

1273

---

Can you explain kafka connector?

1303

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2173

---

Is the value of staging variable stored temporarily or permanently?

993

---

Can we use target hash file as a lookup ?

3323

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2718

---

how to add a new records into source?

1996

---

How to read multiple files using a single datastage job if files have the same metadata?

1244

---

What are datastage sequences?

1116

---

How to read the length of word in unix?

1376

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460

---