Sort Merge
Posted: Thu Aug 09, 2007 9:57 am
Hi all,
I 've a question about the sort merge library in datastage EE (PX).
I thought first that it worked fine only when partitions are sorted on the key(s).
I've been told on dsxchange that the "pre-sort" was unnecessary.
I made a test, the result tells me that the sort order is totally different beetween the 2 methods (pre sort + sort merge vs sort merge only)
Previous tests told me that pre sort + sort merge make good results.
So, who's right?
Thnaks for your help.
I 've a question about the sort merge library in datastage EE (PX).
I thought first that it worked fine only when partitions are sorted on the key(s).
I've been told on dsxchange that the "pre-sort" was unnecessary.
I made a test, the result tells me that the sort order is totally different beetween the 2 methods (pre sort + sort merge vs sort merge only)
Previous tests told me that pre sort + sort merge make good results.
So, who's right?
Thnaks for your help.