DSXchange

Hi ,

How to eliminate duplicate records from the source without using remove dulicate stage and aggregator stage.any body help me the same.

Thanks and regards
ramsdanda

This smells like an interview question. If not, then give me more details, your source, is it a flat file or a database, why do you want to avoid using those stages? Any particular reason.

ramsdanda wrote:Hi ,

How to eliminate duplicate records from the source without using remove dulicate stage and aggregator stage.any body help me the same.

Thanks and regards
ramsdanda

What is your source? Is it sequential file or database?

what is u'r source....

it's a sequential file or any other

Isn't too many same question at same time?
Ramsdanda - The reason been asked is, if you have Database as source stage, you can eliminate the duplicated while selecting by doing a group by.
You can also eliminate by using Sort stage, by assiging a key and Allow Duplicates option to false.

DSguru2B wrote:This smells like an interview question.

I didn't notice that until I looked at all of his posts. Certainly taken together nothing but fishing for interview answers.

I didnt either. I answered his first query. Then when i came to this one i sensed it. Then when i saw a third one i didnt bother commenting.