DSXchange

Hi,

Is there any regression testing tool available for data stage. If not. what will be the approach for doing regression testing in data stage?

Thanks.

None.

About the only available strategy is to record (trace) what happens with the old version of the job design, to record (trace) what happens with the new version of the job design, and to compare these.

This involves planning, and recording prior to making changes, which means that it's too difficult (!) for many DataStage Developers.

I have had great success using DataStage to generate the test data across a wide range of scenarios by letting business users or testers create test data in Excel and then use DataStage to embed it into real records such as flat files or database tables. This gives you a very efficient regression test pack.