Archive for the ‘ETL’ Category
In work with a current client, they required that the execution and processing of certain packages to be configurable via a web interface. In my case, I wanted to proactively enable/disable the importing of certain data sources. If a source system goes down or is in maintenance mode, I need to be able to shut […]Read More
One of the most critical pieces of any data warehouse is how you handle dimensions. Most dimension tables are modeled differently than fact tables because dimension records change more slowly than fact records. During a daily load, you may only have a single column that changes on one dimension record, but you will undoubtedly have […]Read More
On my current client, I’m using Microsoft SQL Server 2008 R2 and SSIS, Integration Services. I’m updating the data warehouse fact tables every hour, but there is a fact table that only needs to be updated once per day. This is mainly because Is able a it’s art long. It’s nba tip off 2014 me. […]Read More
We recently had the opportunity to host a booth at the QlikView Technology Summit held on May 13 at the Dallas Westin Galleria. Our goal was to present our company as a partner for training and consulting services for QlikView customers who aren’t familiar with our company that might be in attendance at the event. […]Read More
Today, analytics have become mainstream in the majority of organizations. Moreover, most of the analytics and data warehousing implementations have been built using traditional relational database platforms such as SQL Server, Oracle, or DB2. As data volumes grow larger and more data sources come online, organizations are hitting the limits of these traditional platforms leading them […]Read More
You can subscribe to our RSS feed.