Hi,
How to sort the data using datastage without using sort stage?
Can any one tell me how to use the UNIX sort commond in transformer?
I am using Datastage 8 version and HP unix.
Thanks in advance.
How canI sort data without using Sort stage?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
Re: How to sort data without using Sort stage
[quote]
How can I sort data using datastage without using the sort stage?
Can anyone tell me how to use the UNIX sort commond in transformer?[/quote]
you can sort the data in the transformer based on a key
How can I sort data using datastage without using the sort stage?
Can anyone tell me how to use the UNIX sort commond in transformer?[/quote]
you can sort the data in the transformer based on a key
Check the input properties of the transformers, there is option of partitioning, in that there is option of sort
1. Stable :- This is for previously sorted datasets..
2. Uniqe :- This will retain only first record if there are duplicates on the sorting key values.
hope this helps
-----------------
MK
1. Stable :- This is for previously sorted datasets..
2. Uniqe :- This will retain only first record if there are duplicates on the sorting key values.
hope this helps
-----------------
MK
I want to sort the file data in the transwarmer. Can you please give me the statement for befou/after routinemk_ds09 wrote:Check the input properties of the transformers, there is option of partitioning, in that there is option of sort
1. Stable :- This is for previously sorted datasets..
2. Uniq :- This will retain only first record if there are duplicates on the sorting key values.
hope this helps
-----------------
MK
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No help at all - this is a server job.mk_ds09 wrote:Check the input properties of the transformers, there is option of partitioning, in that there is option of sort
1. Stable :- This is for previously sorted datasets..
2. Uniq :- This will retain only first record if there are duplicates on the sorting key values.
hope this helps
-----------------
MK
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the data are coming from a database table, you can include an ORDER BY clause in the extraction SQL.
If the data are coming from a file you can use an operating system level sort utility to sort that file - you can do that in a before-job subroutine as mentioned or in a Filter command to the Sequential File stage.
If the data are coming from a file you can use an operating system level sort utility to sort that file - you can do that in a before-job subroutine as mentioned or in a Filter command to the Sequential File stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.