Page 1 of 1
transactional grouping feature
Posted: Mon May 10, 2004 7:45 am
by nilotpalr
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.
Posted: Mon May 10, 2004 7:49 am
by chulett
They all have to come from the same Transformer. Is that the case?
Posted: Mon May 10, 2004 8:18 am
by nilotpalr
Hi,
There are coming from 3 different transformers.
Posted: Mon May 10, 2004 8:48 am
by chulett
Well, then you can't group them.
For whatever reason, that is the rules of the game here.
Posted: Tue May 11, 2004 2:02 am
by ray.wurlod
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.
Posted: Tue May 11, 2004 6:39 am
by chulett
Ah... the old "It's for your own good, Dear" ploy.