There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Unpredictable sorting of "New" output
Hi! I have 2 inputs - source data and existing dimension data. Source data is sorted by Order by clause. Starting with 1 existing record in dimension (unknown member), so it's first time filling. When new records going out of DMSC they are sorted in a strange manner - by blocks or something like this, but not like intput records. This is not the order I'd like to see in my dimension table.
I tried to set IsSorted property with sortKeyPosition on business key field, but it didn't help. Tried do that on source, on ed, on both of them and by apart - no use.
Of course Sort component come to the rescue, but asynchronous component is not desirable.
I found a DMSC property - Number of Processing Threads with value 0, changed that to 1 and got what I want - sorted new records. Tried to change to 2 and returned to the problem.
So what to prefer - left 1 thread (on multicore system), use Sort component or do someting else? In terms of performance and best practice.