There is the option of generating unit tests automatically for existing packages via the ssis Unit API. But how do you recommend creating test data for dimensions if you need to use synthetic data? ” Remember that unit and integration testing is more about verifying functionality, and less about performance.
While this can improve code coverage, I would caution you not to rely on it to verify real functionality. So I like to create a small amount of handcrafted test data that hits the specific scenarios that I need to validate.
I haven’t seen Theresa present yet, but I’m confident she’ll do a great job, and this will be a good session.CBIG was no exception, with some great questions on managing database schema changes when using continuous delivery, how continuous delivery and continuous deployment differ, and how to manage this in a full BI environment.