Parameter Set Limit

nvalia · Post by **nvalia** » Thu Oct 08, 2015 12:13 pm

Hi All,
Is there a Limit to how many Parameters we can have in a Parameter Set?

If Not, is there a realistic threshold post which we should no longer add more parameters to the parameter set?

We currently have 3 Parameter Sets with 1 hitting 30 Params in it

Finally, on same lines is there a limit to number of parameter sets we can use in a job or a realistic number of param sets we should use?

Thanks,
NV

ray.wurlod · Post by **ray.wurlod** » Thu Oct 08, 2015 6:30 pm

No practical limits in either scenario as far as DataStage is concerned.

But you will need to maintain them, and select parameters from long lists. That might be the governing factor.

qt_ky · Post by **qt_ky** » Fri Oct 09, 2015 7:44 am

I agree. It's up to you. We've got some in the 60 to 80 range. Not a big deal but I could imagine at some point it would take more time to go in and find the right one to make a change.

nvalia · Post by **nvalia** » Fri Oct 09, 2015 8:15 am

Thanks for the Insights