DSXchange

Hi,

I am trying to load 16 Oracle tables from Sybase in parallel. Randomly some table or other fails in the process due to connectivity issue.

We my sequence job starts all the jobs run in parallel, is this correct way of performing the data load. We are having in this way to have better completion time.

It is basically a direct load and no calculations are done.

Is there any other alternate way to acheive this?

Thanks

Define "connectivity issue".

Make sure your Oracle DBA has configured a sufficient number of listeners.

There's typically just one but the limit on the max number of and/or rate of connections could be too low. Depends on how this "connectivity issue" manifests itself.

The error message which I got was,
Fatal: ct_fetch failed or canceled during fetch to Sybase table which is the source stage

And this is related to the problem reported by xch2005 how?

Now split up the jobs into batches and executing them from sequence