Browse by Tags

All Tags » ETL (RSS)
13 January 2010 21:54

updating column with a random value

I have been working recently on load testing of our ETL. One of the factors that determines amount of transfered data is a lookup table that is joined to the source. I populated this table with aproppriate values, and then realized that I also need some...
Posted by Piotr Rodak | 1 comment(s)
Filed under: , , , ,
10 October 2009 22:45

DISABLE TRIGGER not captured, SSIS

This post was to be about behavior of SSIS when they insert rows to tables with triggers on them. We had an issue with one of our packs that began to fail 'all of a sudden'. But when I began writing this post and building test SSIS project and...
Posted by Piotr Rodak | 1 comment(s)
Filed under: , , , , , , ,
13 June 2009 00:38

ETL performance test - parallel package execution

I was recently busy with testing performance of our ETL process. Each day we process a number of independent feeds, which will increase in the future. These feeds contain usually similar number of rows. At present we have over 100 hundred feeds that are...
Posted by Piotr Rodak | with no comments
Filed under: , , ,