Page 1 of 1

Testing the Job

Posted: Tue May 23, 2006 1:14 am
by thatiprashant
Can someone pls tell me the way to test the job if its working as expected or not before i can send it to testing department.

thanks
prashant

Posted: Tue May 23, 2006 1:38 am
by ArndW
Prashant - a job has so many possibilities that nobody here can answer your question directly. If your job specifications detail inputs, rules and outputs then you can create a test set of data (and lookups) and outputs and compare that to your job run. This is just an example of one possible test scenario.

Posted: Tue May 23, 2006 9:00 am
by ashwin141
Hi Prashant

As Andrw mentioned there is no specific answer to your question. Though one method which I have been using is taking 5 sample records in source and doing all kind of manipulations on them and checking if its giving the desired output or not. Other methods are using queries in MS access or writing simple shell scripts. You can chose the best option based on what is comfortable and required for you. Some of stages used for debugging are Copy stage, Peek Stage.

Regards
Ashwin