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
mallikharjuna
Participant
Posts: 81 Joined: Thu Nov 30, 2006 7:46 am
Location: india
Post
by mallikharjuna » Tue Mar 06, 2007 11:49 pm
Hi All,
it is possible to remove the duplicates using sort stage in server jobs?
Thanks in Advance
Malli
MALLI
kumar_s
Charter Member
Posts: 5245 Joined: Thu Jun 16, 2005 11:00 pm
Post
by kumar_s » Wed Mar 07, 2007 12:14 am
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:
Post
by parag.s.27 » Wed Mar 07, 2007 2:46 am
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
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Mar 07, 2007 8:02 am
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'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Wed Mar 07, 2007 9:38 am
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
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Mar 07, 2007 10:27 am
Who cares?
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
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Wed Mar 07, 2007 10:28 am
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
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kumar_s
Charter Member
Posts: 5245 Joined: Thu Jun 16, 2005 11:00 pm
Post
by kumar_s » Wed Mar 07, 2007 5:29 pm
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'.
It sounds familiar.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'