JobA : Oracle->(Partition Method : Round Robin) Sorter->Transformer->(Collection Method :Sorted Merge) Dataset
JobB : Oracle->(Partition Method : Round Robin) Sorter->Transformer->(Collection Method :Round Robin) Dataset
The output (order of the data) are same in above to methods. But In the Px guide it is mentioned
If I partition the sorted record by round robin and collect it by round robin is there any chance for the data to loose its order? Is there any risk we have in the JobB when the data order need to be preserved?Note that collecting methods are mostly non-deterministic. That is, if you run the same job twice with the same data, you are unlikely to get data collected in the same order each time. If order matters, you need to use the sorted merge collection method.
Many Thanks
MSR