How about,
Oracle(Source) --> Sort --> Transformer (to pick only the maximum values)--> Oracle(Target)
* Earlier aggregate performs only max operation if I am not wrong, which can be handled in transformer using stage variables.
Search found 1 match
- Wed Jul 08, 2009 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Perfomace Improvement??
- Replies: 22
- Views: 5397