background img
banner
May 20, 2013
434 Views
0 0

Performance Testing on ETL

Written by
banner

How to do performance testing on ETL?

1) First step , find out the load that is being transformed in production
2) Create new data of that same load or Move from Production data to your local performance server
3) Disable the ETL until you generate the load required
4) Take count of the needed data from the tables of the database
5) Note down the last run of ETL and Enable the ETL ,so that it will get enough stress to
transform entire load created ,run it.
6) After ETL completes the run ,again take count of the data created /transformed
a) Note down ETL Run time End and find out the total time it took to tranform the load
b) Findout whether performance time is improved or decreased
b) See that all the expected load got extracted and transfered witETL_Process_Flowhout missing.

Article Categories:
Performance Testing
banner

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.