help with dedup
397315Nov 12 2003 — edited Nov 12 2003I am really struggling to implement following simple functionality with dedup.
Scenarion:
Table merchant (mer_name varchar2(50), mer_num number, id number)
wish to use dedup for following query
SELECT DISTINCT mer_num, mer_name from Merchant WHERE id > 1000;
Problem:
If I make "id" as ingrp parameter into dedup then the query would change to
SELECT DISTINCT mer_num, mer_name, id ...
Which is not what i want.
If I do not use "id" as ingrp parameter into dedup then how do I know, which "mer_num" belongs to which "id".
So, this leads me to believe that perhaps my conceptual understanding of dedup operator could be wrong. Any idea, fellas, how can I do, what I am trying to? also, are there some sample schema and mappings for OWB, which are a bit more involved than simple notebook samples?
Rgds,
Deepak