Datastage developer testing template

mohandl · Post by **mohandl** » Mon Jul 28, 2008 3:22 am

Hi All,

Please any one have the Datastage developer testing template(Unit testing Template) formate , please share the URL or Docs (My id mohanndl@gmail.com)

Thanks In advance,

Mohan

ray.wurlod · Post by **ray.wurlod** » Mon Jul 28, 2008 2:52 pm

I doubt that there can be any "one size fits all" template. While there are similarities between ETL jobs, each is unique to its circumstances. Therefore a template approach seems to me to be ill-advised.

Contemplate what the ETL job needs to do, and design test data accordingly. Run these test data, perhaps using some of the debugging tools, and prove or otherwise that the expected results are being obtained. Make sure that test data include boundary conditions, illegal and invalid values.