transactional grouping feature

nilotpalr · Post by **nilotpalr** » Mon May 10, 2004 7:45 am

I am on Wintows 2000 (DS version 7.0).
I cannot get the transactional grouping feature when I apply multiple links to a OCI stage.

Please advise.
Thanjks in advance.

chulett · Post by **chulett** » Mon May 10, 2004 7:49 am

They all have to come from the same Transformer. Is that the case?

nilotpalr · Post by **nilotpalr** » Mon May 10, 2004 8:18 am

Hi,
There are coming from 3 different transformers.

chulett · Post by **chulett** » Mon May 10, 2004 8:48 am

Well, then you can't group them.

For whatever reason, that is the rules of the game here.

ray.wurlod · Post by **ray.wurlod** » Tue May 11, 2004 2:02 am

The reason is one of synchronization.
There is no way that DataStage could guarantee that you were processing the same input row when the links are coming out of different Transformers, so it simply prohibits grouping of those rows into a single transaction. It's for your own safety, really.

chulett · Post by **chulett** » Tue May 11, 2004 6:39 am

Ah... the old "It's for your own good, Dear" ploy.