grab our rss feed

stevienova.com

Homepage of Steve Novoselac

Entries Tagged ‘ETL Performance’

ETL Method – Fastest Way To Get Data from DB2 to Microsoft SQL Server

May.20, 2009 in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

For a while, I have been working on figuring out a “better” way to get data from DB2 to Microsoft SQL Server. There are many different options and approaches and environments, and this one is mine, your mileage may vary. Usually, when pulling data from DB2 to any Windows box, the first thing you might [...]

View Comments | 4,598 views

SSIS – Slowly Changing Dimensions with Checksum

Nov.22, 2008 in Business Intelligence, Geeky/Programming, SQLServerPedia Syndication

In the Microsoft Business Intelligence world, most people use SQL Server Integration Services (SSIS) to do their ETL. Usually with your ETL you are building a DataMart or OLAP Database so then you can build a multi-dimensional cube using SQL Server Analysis Services (SSAS) or report on data using SQL Server Reporting Services (SSRS). When [...]

View Comments | 6,256 views

  

Business Intelligence, SQL, Geek, Music, Programming, and More!

Welcome to stevienova.com. This is my personal blog. I like to write about mostly geeky stuff (Programming, .NET, Microsoft, C#, SQL, Business Intelligence, iPhone, Apple, Mac, Networking, etc) and other stuff that I just run across and feel like posting up to the net!