Monthly Archives: January 2010

Dramatically Increasing SAS DI Studio performance of SCD Type-2 Loader Transforms

In SAS DI Studio 3.4 (and I imagine in future versions), the prepackaged code for the SCD Type-2 Loader works like this: Does the dataset exist? If not, create an empty dataset with structure and indexes as defined from metadata. Then detect differences between it and the source dataset and the target dataset, expire any […]

Friends in 2009

Lots of differences between now and last year. It’s interesting that now that I’m single, a good percentage of my 10 closest friends are also single. The age distribution is a lot wider now too, I expect this trend to continue as I am no longer meeting friends almost exclusively in school. Summary of Top […]