In normal scenarios Datastage developer does not get access on the production like databases. So in this case, if you have a job which is flexible enough to run with parameters and can prepare test data then it would be very helpful to develop and unit test other jobs.
To create such a job "Row Generator" stage can be used with user defined environment variables. Pass the output to a dataset from row generator or to a file where name is also parametrized. While defining custom environment variables make sure you give relevant names and add these variables into job. Once the parameters are added into job use the values defined into parameters can be hide by using $PROJDEF pseudo code, it make sure that the parameter will take whatever is defined into it.
While you use parameters into row generator make sure you enclose the parameter between two '#' characters for example $Initial_Value is the variable then when used inside row generator it should be #$Initial_Value#
Pass initial value, increment by and limit values through parameters and supply metadata required and the job is available for use.
In normal scenarios Datastage developer does not get access on the production like databases. So in this case, if you have a job which is flexible enough to run with parameters and can prepare test data then it would be very helpful to develop and unit test other jobs.
ReplyDeleteTo create such a job "Row Generator" stage can be used with user defined environment variables. Pass the output to a dataset from row generator or to a file where name is also parametrized. While defining custom environment variables make sure you give relevant names and add these variables into job. Once the parameters are added into job use the values defined into parameters can be hide by using $PROJDEF pseudo code, it make sure that the parameter will take whatever is defined into it.
While you use parameters into row generator make sure you enclose the parameter between two '#' characters for example $Initial_Value is the variable then when used inside row generator it should be #$Initial_Value#
Pass initial value, increment by and limit values through parameters and supply metadata required and the job is available for use.