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!!!!

What are datastage sequences?

680

---

What is orabulk stage?

641

---

Define project in datastage?

670

---

what is the use of surogate key in datastage

1825

---

how to abort the job its matain duplicates?

2113

---

---

What is the precedence of stage variables,derivations, and constraints?

604

---

Can we use target hash file as a lookup ?

2820

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1055

---

Define repository tables in datastage?

706

---

How many types of views are there in a datastage director?

841

---

root tree will find which is server job and which is parallel job?

1459

---

How do y read Sequential file from job control?

14428

---

Which algorithm you used for your hashfile?

697

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

904

---

What are sequencers?

618

---