How do you perform testing of jobs

[babbu9]

Hi
I woud like to know how one performs testing of the jobs created with DS. What kinds of testing can be done and how?
Please inform.
Bob

[vmcburney]

We usually go for unit testing (development team), system testing, system integration testing, performance testing (test team) and user acceptance testing (user representatives).

It is important to run against "real" data and real data volumes or as well as creating specific test scenarios. On one project we had business users create and maintain test data in Excel spreadsheets and we had a DataStage jobs to extract this data into real source files for regression testing.

[chulett]

In other words, not really all that different from testing anything else. There's nothing magical about it just because it's a DataStage job.

[ray.wurlod]

I'll add one more to Vincent's list, for more mature projects into their maintenance cycle, and that is regression testing. Regression testing can simplistically be described as testing that proves changes haven't broken anything else.

There is a wide-open marketplace out there (not just in DataStage) for anyone with skills in QA, particularly taking pains to ensure that all - or, more realistically, all possible - bases are covered. Being extremely cynical is a distinct advantage. Designing test data is a fascinating sub-genre.