Parameter Sets
Previous  Top  Next

A Parameter Set is a group of parameters. Extracting job parameters will create the Master set. There is only one version of a given parameter name. It has to exist in the Master set. When you create parameter sets then you can quickly copy a set or group of parameters to a job or a data set. Data sets will be explained later. A typical set would be to connect to a specific database. Usually it takes 3 parameters to connect to a database. The database name, user and password are normally this set. You may have multiple sources so you may need parameter sets for each of these. If you watch the tutorial then you will see 2 sets demostrated Source and Target. Source is the main source database parameters like SourceDSN, SourceUser and SourcePwd. Target has a similar group of parameters TargetDSN, TargetUser and TargetPwd.  
 
Usually you want to create a Parameter Set with both Source and Target parameters. This parameter set is usually applied to a sequence. A sequence needs all the parameter values for all the jobs it runs. This is very important in getting your sequences setup properly. It is very easy to find all the jobs which start with letters "Seq" if that is how you name your sequences. You can do this with a filter. Filters will be explained later in more detail.  
 
Parameter sets cannot be copied to multiple jobs in one step. This is to save you from accidently copying parameters to all jobs. It would be a lot more difficult to delete all these parameters from many jobs than it is to copy them to one job at a time.  
 
Parameter Sets and Data Sets were created to help you quicly clean up your parameters. If your parameters are clean and standardized then the odds of someone updating the wrong database is much higher than without Parameter Navigator. Plus it save you a lot of development time.  
 
More Detail