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
Most ETL systems (at least that I have seen/studied/worked on) that populate data warehouses run something like 1) Load Dims a) populate an unknown b) populate dim data 2) Load Facts a) join/lookup to dim’s, and if no match, set as “unknown” dimension record 3) Process Cube This type of system works in [...]
View Comments | 2,008 views
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
