I have a shared container with two outputs. In one job that uses the shared container, one of the outputs goes straight to an OCI stage. The OCI is set to "
Insert Rows Without Clearing",
array size=250,
rows per transaction=0. I want it to commit regularly, so I change the
Rows Per Transaction to 250 (it lets me do this) and hit OKon the Dialog box (saves OK; no error). When I open up the OCI stage again, Rows Per Transaction is back to 0.
I have another job using the same container (one output direct to OCI) and it does the same.
I can output the Shared Container to a Transformer stage and propogate cols through to the OCI (ie. dummy transformer) and the problem is solved. I am concerned that there may be greater problems involving Shared Containers of which I should be aware.
Any ideas what is going on? I cannot find this discussed elsewhere in the forum.