It’s tricky but the short answer is yes, sorta. There are certain limitations, of course, but with some creative problem solving, you can do quite a bit with this ETL tool.
Data Integration
8 posts
If you’re like me or anybody else who travels frequently (or perhaps just lives in a particularly large city), you’ve probably become familiar with yelp, foursquare, or any of a number of different sites and apps designed to help you find somewhere to eat or other goods and services in […]
If we were to define “ad hoc” straight from the Merriam-Webster Dictionary, it would yield, “for the particular case at hand without consideration of wider application.” The goal of an ad hoc analysis is to close in the gaps that may have been left by a business’ regular reporting. In […]
One of the most powerful parts of Cognos Insight is the ability to add different themes to your workspace. This can cause your widgets to pop out a little more, and give a little more color. Sometimes we want a little bit more than what we are given in the […]
Dealing with dates in Cognos can sometimes be a daunting task. Dates should be straightforward, but sometimes they take extra work to get what you want. Your data is designed to list the date of the transaction, but maybe you only care about data on a per week, per month, […]
I was wandering around YouTube one weekend looking for something mentally stimulating when I came across the Monty Hall problem. For those who are not familiar, the problem is named after the host of the gameshow Let’s Make A Deal. On the show, there was a game where the contestant […]
Joseph A. di Paolantonio Benjamin B. Goewey Much of the current hype in Data Management & Analytics today is around the concept of Big Data, and Hadoop is at the center of the hype storm. The other two hot areas are Mobile & Elastic Cloud Computing. Cloud is central to […]
When running an ETL in Pentaho Data Integration (Kettle), logging is normally done in a log file on the local system. When running an ETL through Carte or the BI server, it will add the information to their own separate local log file. These directions will allow the log information […]