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

Can you filter data in hashed file?

3780

---

Explain datastage architecture?

1405

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3350

---

How do you run datastage job from the command line?

1094

---

CHANGE CAPTURE

1311

---

What are the primary usages of datastage tool?

1075

---

Can you explain engine tier in information server?

1138

---

What could be a data source system?

1023

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2213

---

How many areas for files does datastage have?

1156

---

What are the processing stages?

1105

---

Can you explain repository tables in datastage?

1412

---

What is the difference between an operational datastage and a data warehouse?

1157

---

What is ds designer?

1109

---

What are the components of datastage?

1124

---