it is possible to remove the duplicares using sort stage?

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
mallikharjuna
Participant
Posts: 81
Joined: Thu Nov 30, 2006 7:46 am
Location: india

it is possible to remove the duplicares using sort stage?

Post by mallikharjuna »

Hi All,

it is possible to remove the duplicates using sort stage in server jobs?

Thanks in Advance
Malli
MALLI
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

No.
Not just using Sort stage, but may be using Sort coupled with Transformer and its stage variables.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
parag.s.27
Participant
Posts: 221
Joined: Fri Feb 17, 2006 3:38 am
Location: India
Contact:

Re: it is possible to remove the duplicares using sort stage

Post by parag.s.27 »

mallikharjuna wrote:Hi All,

it is possible to remove the duplicates using sort stage in server jobs?

Thanks in Advance
Malli
If you can use a Hash File, then declare the primary key..and the hash file will take care of it...

But please note that for any duplicate entry, the hash file will retain the last entry in the file...
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or sort the data then use stage variables... there's a number of different ways. However, the answer to the question as asked is 'no'. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

This is possible in a px sort stage with unique option selected.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Who cares? :lol:

Server question posted in the Server forum, so you got a Server answer.
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Well it might be one of those days when you hear that something can be done with a particular stage. But the information was'nt comple as to on what animal. I clarified that :wink:
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

chulett wrote:Or sort the data then use stage variables... there's a number of different ways. However, the answer to the question as asked is 'no'. :wink:
It sounds familiar. :wink:
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply