Etl's performance

Version 1.6 introduces tests for Etl.

More information on how to define an Etl in a system-under-test can be found on the page named Etl

Performance

It’s also possible to test the performance of your Etl by providing an timespan for the execution of the run. If the run is slower than expected the test will fail, else it will succeed. Note that the effective result of the execution is not considered during this test. So if your package is failing after 1 second and your maximum was of 5 seconds, your test will succeed.
A full sample would be:
<test name="Etl is faster than 10 seconds" uid="0002">
  <system-under-test>
    <execution>
      <etl path="Etl\" name="Sample.dtsx"/>
    </execution>
  </system-under-test>
  <assert>
    <fasterThan max-time-milliSeconds="10000"/>
  </assert>
</test>

Last edited May 12, 2014 at 9:34 PM by Seddryck, version 2

Comments

No comments yet.