Page 1 of 1
Changing the Record Count & Array Size
Posted: Wed Dec 08, 2010 7:35 pm
by sri_vin
Hi
We have to change the array size and record count from 2000 to minimum no say 1 for every odbc stage.
Is there is any way we can change them globally?
Your help on this is much appreciated.
Regards
Sriram
Posted: Wed Dec 08, 2010 10:01 pm
by ray.wurlod
Export the entire project, edit the DSX file, then import the entire project with "overwriting" set.
Posted: Thu Dec 09, 2010 10:15 pm
by sri_vin
ray.wurlod wrote:Export the entire project, edit the DSX file, then import the entire project with "overwriting" set.
Thanks Ray
How about for the new ones? Is there a place we can change the default settings?
Sriram
Posted: Fri Dec 10, 2010 1:26 pm
by SwathiCh
Add a new environment variable as ARRAYSIZE in admin and default it to '1'.
And in all new jobs development parameterize the arraysize value with the variable defined above so that when we change value at admin level it will propagate to all jobs.
for the existing jobs I think ray suggsted method will be better.