Amateur loads of version rows, slowly changing dimension (SCD) type 2, loop through the incoming data one record at a time, like the SCD transform in Microsoft’s SSIS. This works,
I recently read The Speed of Trust. This book explains why trust within an organisation and with external parties is a key differentiator and source of competitive advantage. Covey explains
One of the wonderful aspects of building software is that there are few limits to your imagination. You can create almost anything. The only limit that I regularly encounter is
I’ve recently had some trouble with SQL Server Integration Services behaving badly. SSIS manages its own memory use, and ordinarily does a good job. By throttling inputs SSIS can run
I’m going to begin by saying that you should always use set based operations instead of loops when set based operators are an option. If you don’t understand that please
RSS - Posts