by XTIVIA | Dec 9, 2015 | Blog, Business Intelligence, Data Warehousing, Perspectives
What would you like your business intelligence program to look like two years from now? Imagine that your software applications shared common data, and that data was clearly defined and understood by those who managed and used it. Imagine business teams...
by XTIVIA | Jul 19, 2015 | Blog, Business Intelligence, Data Warehousing, Databases
SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the analysis in an XML file, which you can view using the Data Profile Viewer. Before we review how to use the...
by XTIVIA | Oct 7, 2013 | Blog, Business Intelligence, Databases
At XTIVIA we often receive requests from clients who require somewhat more than the average database administration tasks. Recently I had a request to help a client pull normalized data from one object in one data source and merge that data with data in two...
by XTIVIA | May 7, 2013 | Blog, Business Intelligence
Often times when implementing data integration projects – we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row. I started implementing a simple data flow in SSIS. The idea was simple and has...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Absolutely! The reports from Gartner are great (at least from my perspective) and there is a lot of useful information in them. I found the latest one particularly engaging. As I read through the report, I started thinking about what it means to us (as practitioners...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Two bits of Information I picked up from our principal Informatica Architect. When I used these, it did really work wonders. Aggregators and joiners should have sorted input. The Sorter Transformation sorts rows more efficiently that the Aggregator...