Page 1 of 1

Diff between the multiple instances and Parameterize the Val

Posted: Fri Oct 19, 2007 12:56 am
by Magesh_bala
Hi All,

can anyone please explain the difference between Multiple instances and parameterize the values in the job. whether both will perform the same action????

Posted: Fri Oct 19, 2007 2:01 am
by ArndW
The two items, "multiple job instances" and "parameterizing values" are not related apart from both being part of DataStage. One is used to run the job mutliple times in parallel, the other is used to pass runtime values to a job.

Re: Diff between the multiple instances and Parameterize the

Posted: Fri Oct 19, 2007 3:20 am
by baglasumit21
Magesh_bala wrote:Hi All,

can anyone please explain the difference between Multiple instances and parameterize the values in the job. whether both will perform the same action????
There is a lot of difference between Multiple instances and parameterize the values in the job. By specifying multiple instance you can run a single job multiple times parallely i.e. more than one instance.

While parameterize the values in job means specifying different values for something (like username, password, DSN, etc)

So you can summarise that suppose you have a job to load data based on date, so you can parameterise the date, but if you specify multiple instances than you can run single job parallely for different date parameters.