Sybase OC Stage with multiple read links

[trammohan]

Hi,

When I use Sybase OC with multiple read links ( to read data from mltiple tables with same Database ), Job is running successfully with this warning

Warning
Sybase_OC_642: When checking operator:
Passive stages should have either one input link or one output link.
Other configurations may run, but process meta data will not be reported accurately.
This stage has '0' input links and '2' output links.

Any Idea why job is generating this warning?..

Thanks
trm

[ray.wurlod]

The stage only supports one output link. You can not have multiple read links. You would need multiple stages. You can combine these within the job, for example using a Funnel stage.

[Poovalingam]

Hi all,
I'm also getting the same warning when I'm using DRS Stage to connect to Oracle DB. I'm having 1 stream input and 3 reference links.

Warning Message is,

\<stage name>: When checking operator:

Passive stages should have either one input link or one output link.

Other configurations may run, but process meta data will not be reported accurately.

This stage has '0' input links and '4' output links.\

But, the job is running fine. All required records are successfully populated.

Will it cause any issue if I keep the same design? Kindly advice me.

Also, Please let me know, why DS displays this warning message when DRS Stage supports more than one link to the next stages.

[ray.wurlod]

Because process metadata may not be accurately reported, and DataStage needs to alert you to that possibility.

[Poovalingam]

Thanks Ray. I will go with one DRS Stage per one link.

Thanks all.