Create Parameter Set Procedure in IBM Info Sphere Data Stage

Parameter Set :

Create Parameter Set Procedure in IBM Info Sphere Data Stage:

Procedure to create Parameter Set:

1.      Choose File > New to open the New dialog box.

2.      Open the Other folder, select the Parameter Set icon, and click OK.

3.      The Parameter Set dialog box appears.

4.      Enter the required details on each of the pages as detailed in the following sections.

Parameter Set àGeneral tab
Use the General page to specify a name for your parameter set and to provide descriptions of it.

Parameter Set à Parameters tab:

Use this page to specify the actual parameters that are being stored in the parameter

Set

Parameter Set àValue tab:
Use this page to optionally specify sets of values to be used for the parameters in this parameter set when a job using it is designed or run.

1.Parameter Set àGeneral tab
Use the General page to specify a name for your parameter set and to provide descriptions of it.

Parameter Sets
General	Parameters	Values
Parameter set Name:
Ps_StagingDB
Short Description
Parameter Set  cretaed for connecting for  StagingDB
Short Description

2.Parameter Set à Parameters tab:

Use this page to specify the actual parameters that are being stored in the parameter

Set

Parameter Sets
General	Parameters	Values
	Paramater name	Prompt	Type	Default Vaue	Help Text
1	HostSerever	Server	String
2	UserName	UserId	String
3	Password	Password	Encrypted

3.Parameter Set àValue tab:
Use this page to optionally specify sets of values to be used for the parameters in this parameter set when a job using it is designed or run.

Parameter Sets
General	Parameters	Values
	Value File name	HostSerever	UserName	Password
1	DevdDB	DevdDB	abreddy	******
2	ProdDB	ProdDB	abreddy	******
3	TestDB	TestDB	abreddy	******

Run Time Prompt Display Window:

The Above Parameters  prompt when u run the job immediately prompt display and ask the details of above

Parameters	Limits		General
Name		Value
Ps_StagingDB		DevdDB
Ps_StagingDB		ProdDB
Ps_StagingDB		TestDB
Server		ABC
UserId		abreddy
Password		******

Create Parameter Set Procedure in IBM Info Sphere Data Stage, Create parameter set procedure, ETL Parameter set Creation procedure, ETL Tool, IBM Info Sphere Data Stage, Data stage