Answer Posted / vinod upputuri

Unfortunately, I didn't got the logic behind the YOUR answer.

According your 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:
251
251
456
456
951
985
251,2
456,2
951,1
985,1

Then your are specifying that count=1 then you get the unique records.

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

Unfortunately this is not our desired out put, our out put is: 251
251
456
456

SO, YOUR LOGIC IS NOT ACCEPTABLE. TRY TO THINK FOR DESIRED OUTPUT !!!!

in order to get the desired out put i using the lookup-stage
in lookup i am going to lookup the out put from filter stage which is 951,985 with main data there i will specify the condition as reject:
so YOU will get the desired output!!!!!

If you can prove the above logic is wrong send me the mail!!!!

how do u catch bad rows from OCI stage? And what CLI stands for?

2852

---

Explain connectivity between datastage with datasources?

1040

---

What is a ds designer?

1112

---

why do u need the IOS upgradation in a FC switch

2335

---

Triggers,VIEW,Procedures

1262

---

How to implement complex jobs in data stage?

1157

---

Explain the importance of surrogate key in data warehousing?

1231

---

What is orabulk stage?

1103

---

Difference between server jobs & parallel jobs?

1129

---

what is ds administrator used for?

1216

---

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 ?

2074

---

What are the differences between datastage and informatica?

1228

---

What are the partitioning techniques available in link partitioner?

2326

---

Terminate Activity

1335

---

What are the main features of datastage?

1350

---