Merge Error

sdevashis · Post by **sdevashis** » Fri Nov 21, 2003 11:46 am

Hi,
I am trying to create a job where I have same data coming from two sources. I do some tranformation on each of the sources and then pass the data to a merge stage something like below

SOURCE1 --------->TRANFORMER1----------->
MERGE----------->TARGET
SOURCE2 --------->TRANFORMER2----------->

During compiling it gives an error saying the stage doesnt support active-to-active input or output.

But if I remove the transofrmers inbetween then the job goes fine which is no acceptable.

IS THIS IS BECAUSE I AM NOT USING ENTERPRISE EDITION

Please advise

Jay · Post by **Jay** » Fri Nov 21, 2003 4:13 pm

Even I am new to DS. I tries to simulate your design. But it said Merge stage cannot accept stream links!!!

ray.wurlod · Post by **ray.wurlod** » Fri Nov 21, 2003 10:54 pm

What the message is telling you is that, in the 390 environment, DataStage will not allow two active stage types to be connected together; more exactly, that the Merge stage can not have an active stage type feeding its inputs.

Consider the Join stage.

Alternately, and probably better for your design, insert a fixed width flat file between each Transformer stage and the Merge stage.

sdevashis · Post by **sdevashis** » Sat Nov 22, 2003 6:39 am

Hi,
I am extremely sorry as I wrote Link Collector as Merge.
The scenario is like below.

SOURCE1 --------->TRANFORMER1----------->
Link Collect----------->TARGET
SOURCE2 --------->TRANFORMER2----------->

Sorry for my stupidity.

ray.wurlod · Post by **ray.wurlod** » Sat Nov 22, 2003 7:48 pm

In that case, you're not talking about a DS 390 job. There is no link collector stage in DS 390.

mhester · Post by **mhester** » Sun Nov 23, 2003 7:34 am

Devashis,

There are two ways to solve the issue.

1) From the properties page of the job click on the Performance tab and uncheck "Use project defaults". This will allow you to then choose "Enable row buffering" and choose the "Inter process" radio button.

Or

2) use an IP (Inter Process) stage (passive) between your transforms and the collector. You will need one for each transformer stage in the job that feeds the link collector.

You can also set this at the project level, although it would not be recommended for many different reasons.

If you use either method of row buffering in your job you should avoid using any kind of COMMON block.

Regards,

Michael Hester

sdevashis · Post by **sdevashis** » Tue Nov 25, 2003 5:13 am

Thanks Mhester & Ray.
I could get over the problem.

Jay I hope you also got a work around with the advises..

Thanks again.