Introduction There’s quite a bit of hoopla about MDM lately, mostly due to awareness. While “Lacks needed data” was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), “Insufficient or inadequate master data” made a decent showing at second with 17 votes (see Table …
Continue reading Master Data Management 101: Standardize Units of Measure
Category:Uncategorized
Master Data Management 101: Standardize Units of Measure
Introduction There’s quite a bit of hoopla about MDM lately, mostly due to awareness. While “Lacks needed data” was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), “Insufficient or inadequate master data” made a decent showing at second with 17 votes (see Table …
Continue reading Master Data Management 101: Standardize Units of Measure
Master Data Management 101: Standardize Units of Measure
Introduction There’s quite a bit of hoopla about MDM lately, mostly due to awareness. While “Lacks needed data” was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), “Insufficient or inadequate master data” made a decent showing at second with 17 votes (see Table …
Continue reading Master Data Management 101: Standardize Units of Measure
Master Data Management 101: Standardize Units of Measure
Introduction There’s quite a bit of hoopla about MDM lately, mostly due to awareness. While “Lacks needed data” was cited as the number 1 problem (with 21 votes) in data warehouses in the recent IBM Data Warehousing Satisfaction Survey (2007), “Insufficient or inadequate master data” made a decent showing at second with 17 votes (see Table …
Continue reading Master Data Management 101: Standardize Units of Measure
SSIS Design Pattern – Read a DataSet From Variable In a Script Task
Introduction One of the things I appreciate about SSIS is the script elements. There is a lot of functionality built into the engine out of the box but I like the idea of having a Script Task on the Control Flow and a Script Component on the Data Flow just in case. Last month I used …
Continue reading SSIS Design Pattern – Read a DataSet From Variable In a Script Task
Richmond Code Camp 4
Richmond Code Camp 4 is Saturday 6 Oct 2007, 8:00 AM – 6:00 PM at ECPI-Innsbrook in Glen Allen, VA (Richmond’s West End). If you’re going to be in the area, stop by and catch a session or two! :{> Andy
Accessing Parent Package Variables In Child Packages… Without Configurations
If you’ve needed to close the information loop in an SSIS Parent-Child package architecture (also known as Master Package Design), Steve Fibich has a post is for you! This is the neatest thing I’ve seen in a long time. Once a child package is called, the parent package variables are available for reference and update – without …
Continue reading Accessing Parent Package Variables In Child Packages… Without Configurations
From my PASS presentations: Custom Test Condition Code: ETL Counts (Team Edition for Database Professionals)
I’d like to thank the people that attended my sessions at the 2007 PASS Summit in Denver this week! I had a blast and hope you all did as well. The code will be available from the PASS website and on a DVD. For those in my sessions, I promised I would post the code …
Continue reading From my PASS presentations: Custom Test Condition Code: ETL Counts (Team Edition for Database Professionals)
PASS Presentation – Team Edition for Database Professionals
I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month! One presentation is entitled Applied Team Edition for Database Professionals. The focus is TEDP in action for database development. I cover a lot of the material in my Testing the Database chapter of the new Wrox book: Professional …
Continue reading PASS Presentation – Team Edition for Database Professionals
PASS Presentation – SSIS Development And Testing
I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month! One presentation is entitled Integrate Your SSIS Development. The focus is on SSIS development and testing. I touch on continuous integration and test-first development – using Team Foundation Server for the CI and Team Edition for Database Professionals to …
Continue reading PASS Presentation – SSIS Development And Testing