Generic job to migrate tables from sybase to oracle

[aschindler]

Hi Team,

I need to develop a parallel job to migrate tables from sybase to oracle server.
I'm using sybase connector and oracle connector with create target table YES and RCP enabled in job properties.
but getting below error in the oracle stage,though enabled RCP
The connector could not validate the input schema,specify atleast one column in the input schema.

Please help.

[ray.wurlod]

Last time I did one of these (different souce and target from yours) I used a sequence to run a server job that created the SELECT statement by reading the system tables, and passed the SELECT statement to the main job as a job parameter. Worked beautifully.