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.

describe the Steps to confiure a Qlogic switch

2386

---

What is difference between server jobs & parallel jobs?

1042

---

Difference between data warehousing and olap?

1097

---

What are the functionalities of link partitioner?

1023

---

What are the different layers in the information server architecture?

1129

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1394

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2089

---

What all are the different way to run a job?

1096

---

What are stage variables and constants?

1152

---

Difference between server jobs & parallel jobs?

1083

---

What are the different options associated with dsjob command?

1444

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2025

---

What is the different type of jobs in datastage?

982

---

what is use of SDR function?

5178

---

Describe the architecture of datastage?

1011

---