Database testing is a critical aspect of development. BI and Data Warehouse testing is another level of testing that is key to ensuring the quality of your data throughout your BI system. Data quality, or lack of it, is a focus of many these days. Bad data is an epidemic, and data testing is the key to solving the epidemic while allowing you to have confidence in your data.
Pragmatic Works is excited to once again participate in the 18th annual Professional Association of SQL Server Summit (PASS) in Seattle, Washington. PASS Summit is the world's largest technical training conference for Microsoft data professionals to come together and gain access to the latest training and educational opportunities.
Even though many people think data warehouses ETLs (extract, transform and load) should contain insert data flows only, the vast majority of people I work with also have to deal with updates. Many also have to handle marking data warehouse rows as IsDeleted = "Y" in their ODS and EDW data repositories.
If you are working with a dimension table with less than 500K rows (an estimate), a traditional lookup task might work just fine. The data flow would look like this:
Do you work with data and want to learn more about developing using Tableau? If you’re looking to break into using Tableau, our new in-depth course, Introduction to Tableau, is the course for you! This course will teach you all the basics and fundamentals you’ll need to become a thorough Tableau developer.
Fall is finally here! For most, that means football season is back in full swing, the air is starting to feel crisp and cool, and you can find pumpkin-flavored treats everywhere. Here at Pragmatic Works, we are ramping up for a busy month. With multiple bootcamps and PASS Summit 2017, you'll find us traveling all around the country educating tech professionals about our software suite, training offerings and consulting services.
Check out what we have coming up this month!
Need help with this topic? Ask the author below.