DSXchange

Hi All,

We have a requirement where we need to connect to over 20 Source Databases with different Connection Information and so each will need atleast params for DSN, User and Password..My questions

1. Is there a Limit on the the Number of Parameters we can use in a Parameter set or any performace impact if we have say 60 parameters in one?
2. Should we use all these 60 in 1 Parameter_Set and so we have only 3 different value files, one each for DEV/UAT/PROD?
2. Or Should we have one paremeter_Set for each connection, that would mean 20 parameter_sets in each Env, so total 60 across DEV/UAT/PROD?

Note: We will also have 1 additional parameter_set for all Directories parameterization, one each for DEV/UAT/PROD

Thanks and Appreciate your help

There is no limit. Do whatever is best for your purposes, not neglecting ease of maintenance.