Hi
In my project we are doing Sorting on some business columns and want to load the sorted data in a dataset.
But my concern is since input data will move to different nodes of the dataset, Will the sorting remain preserved in the dataset?
Thanks in advance!
can target dataset preserve pre sorted data?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 99
- Joined: Mon Sep 03, 2007 7:49 am
- Location: Stockholm, Sweden
Depends on which database (stage) and read method you are using. If you're not reading data from each database partition(node) your data will be returned on a single node and thereby your dataset will remain as a single node when using SAME partitioning.
Using DB2EE-stage for example and read method table would return data on as many nodes as your db is configured on and using db2 hash algoritm, so using SAME partitioning in this case would preserve your sort and partitioning as from the db.
Using DB2EE-stage for example and read method table would return data on as many nodes as your db is configured on and using db2 hash algoritm, so using SAME partitioning in this case would preserve your sort and partitioning as from the db.
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: