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
Parameter_Set
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: