sybase parallel extract
Posted: Wed Jun 22, 2005 3:16 am
When using the Sybase OC stage to read data there is the option to work parallel (stage-advanced tab, execution mode).
In the oracle stage there is something likewise, but there you have some control about how it will run parallel because it askes for a partition table. In sybase we don't seem to have any control about how it works.
Does anyone know something about the internal mechanism how the partitiong of data is done(on oracle it uses rowid's) and maybe how we can control it?
related question: if we would use this stage on a sybase IQ, what would be the effect (There is a seperate IQ-load stage, but not for reading).
In the oracle stage there is something likewise, but there you have some control about how it will run parallel because it askes for a partition table. In sybase we don't seem to have any control about how it works.
Does anyone know something about the internal mechanism how the partitiong of data is done(on oracle it uses rowid's) and maybe how we can control it?
related question: if we would use this stage on a sybase IQ, what would be the effect (There is a seperate IQ-load stage, but not for reading).