My previous blog post was about the SSIS Lookup task and how it really works. Now that I have shown that the Lookup task shouldn’t be used for one-to-many or many-to-many joins, let’s take a look at the Merge Join transformation task. If you follow along with this blog, you will learn a little tip that will eliminate the requirement for you to add a SORT transformation task within your data flow task.
Recently, I was tasked with building a hierarchy using multiple dimensions. I was advised to use a named query or materialized view to accomplish this because SSAS doesn’t have the capabilities to read the columns/attributes from multiple dimensions. Since I have done this before, I decided to take the AdventureWorks database and give a step-by-step tutorial of how to accomplish this request. Let’s get started!
How would you like your corporate data turned into a beautiful, easy-to-read graph with one simple command?
As the popularity of big data continues to grow, the business intelligence and analytics software market is reaching new levels of maturity.
On April 15, 2015, Microsoft released and then shortly thereafter recalled SQL Server 2014 Service Pack 1 after citing some installation issues. Today, there is good news.
Starting with a Windows 10 preview event, moving to its own developer-focused Build 2015 and finishing with the enterprise IT-oriented Ignite, Microsoft has recently shown its tech hand.
A few months after the release of PostgreSQL Version 9.4, there are already DBAs discussing the 9.5 update.
Welcome to the information age, a time when businesses have access to a wealth of different data, ranging from first-party collected facts to Web analytics metrics. While organizations have always used data in one form or another to drive decision-making processes, companies nowadays are easily gathering information from CRM and ERP systems as well as discovering a variety of different data sources, including social media, cybersecurity reporting tools and industry studies.
One of the most critical initiatives for any organization involves building a business intelligence infrastructure and solution. Before embarking on this endeavor, it is key to put the proper resources in place for a successful business intelligence implementation and evolution.