by XTIVIA | Mar 7, 2017 | Blog, Business Intelligence, Data Warehousing
It’s been estimated that up to 60% of the effort in building a data warehouse can be spent in developing the ETL processes that are needed to copy data from source systems and transform it before loading it in to the data warehouse. Many of the ETL processes,...
by XTIVIA | Jan 7, 2016 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...
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 | Sep 19, 2015 | Blog, Business Intelligence, Data Warehousing, Databases, Enterprise Infrastructure
20 years ago when I got a 80386 Windows-95 PC with ¾ inch Floppy Drive, 4 MB RAM (I don’t remember the HDD capacity – I believe it was around 120MB or so) from my infrastructure guy, I felt like I’m hero on the street advertising to everyone the great piece of...
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 Kathleen Long | Feb 27, 2015 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
SUMMARY: This guide details the technical process for establishing connections between SQL Server Reporting Services (SSRS) and non-SQL data sources by installing the Microsoft Access Database Engine and configuring specific OLE DB or ODBC connection strings....
by Kathleen Long | Dec 8, 2014 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
While doing research for an upcoming add on to our standard Health Checks, I have been reviewing the different option to set in the configuration file for SQL Server Reporting Services. There are memory settings which should be addressed, especially if you are running...
by XTIVIA | Oct 31, 2014 | Blog, Data Management, Data Warehousing
So I encounter the looping chain of synonyms error every once in a while and it seems pretty simple to understand, though I thought I would take a minute to demonstrate how it works. ORA-01775: looping chain of synonyms – Basically means that you created a...
by CRM Team | Oct 22, 2014 | Blog, Business Intelligence, Customer Relationship Management, Data Warehousing, Perspectives
1. There are two primary techniques used in today’s statistical world a. Descriptive techniques describe and summarize data b. Inferential techniques allow us to estimate and draw conclusions about populations from samples 2. Data can be formally categorized in three...
by XTIVIA | Sep 26, 2014 | Blog, Business Intelligence, Data Warehousing, Enterprise Infrastructure
Talend Open Studio does (TOS) not have versioning like the Talend Integration Suite (TIS). In order to set up versioning for TOS we decided to use Tortoise SVN as the client & Slik SVN as the server. After installing Tortoise SVN & Slik SVN, close TOS if you...
