ETL Using the Voracity Pivot / Unpivot Wizard by Claudia Irvine A new wizard in the IRI Workbench GUI for Voracity can pivot or unpivot relational data. A pivot transformation converts rows to columns and is helpful when dealing with denormalized tables. Read More
Data Migration Just How Fast is ODBC? A “Loaded” Comparison. by Chaitali Mitra The Opening Question ODBC gets a bad rap for speed sometimes … but should it? You’d think from what’s posted online that ODBC is intrinsically slow: Microsoft disagrees in the case of SQL Server. Read More