Page 1 of 1

"Tap" parallel stage?

Posted: Tue Nov 08, 2011 5:00 pm
by evee1
I was wondering whether there is a parallel stage in Datastage that acts as a "tap"? It's like it to take two inputs, one is my nomal data stream, and another uses one value from abother input that acts as a switch to turn on and off data flowing from the first input.

I am using join for this at the moment, but maybe there is some specialised stage for that (a kad a quick look at all other stages but none of them seems to have this funcionality).

Posted: Tue Nov 08, 2011 5:23 pm
by ray.wurlod
Not a single stage, unless you create your own (Build stage).

The buffering mechanism within parallel jobs handles your requirement non-absolutely - if the producer stage is producing data faster than the consumer stage can process those data, then the buffer "resists" input, effectively slowing down the producer stage.

What are you actually trying to achieve with this job design?

Posted: Tue Nov 08, 2011 5:44 pm
by evee1
I'm trying to solve the problem described in viewtopic.php?t=142966
The number of reject records should act as a filter for "good" records. If there are no rejects the job finished successfullyt and inserts/updates data in the target table, but if there are some rejects they get logged in reject table and the job aborts.
I implemented the "tap" using join and filter stages and it works now (I will add my comments later to the other thread after I test my job properly). I was just wondering whether I could reduce number of stages....