DSXchange

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

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.

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.

Thanks for the Insights