I’m preparing a chapter that describes our research at Santa Clara University. While reading, I found a paper with a [nowadays] funny comment about the search engine infrastructure of Alta Vista.
Continue reading
Regardless of whether you are working on a traditional or big data project, business intelligence analytics or transactional systems, new or legacy systems – data is at the heart of what we do and therefore data modeling is a critical success factor of any development effort. Improve you data modeling skills this year at DMZ!
My session with Dan Linstedt on Data Vault 2.0 modelling got accepted by TDWI. See the conference program for more details and to see what you can expect from our session. Working hard to get it ready now.
Over the Christmas season and New Year break, I have been working on my blog www.dwhwiki.info.
Continue reading
Just went to a session at the HS Hannover, got clicked…
Nice: a mobile client for Pentaho BI is available:
Continue reading
Sometimes, when users enter a new member to an entity in Master Data Services (either using the Web frontend or MS Excel), they experience the following error:
Continue reading
A list of country codes, especially interesting for data warehousing projects:
Continue reading
Just stumbled over the problem how to successfully skip trailing blanks in my fixed length flat file and how to have a CR/LF line feed instead of the UNIX one.
Continue reading
#DWH #BI #Automotive
In my last article, I focused on Vehicle Identification Numbers (VINs), about their structure and how to verify them in a data warehouse setting. This article focuses on an implementation of a VIN Validator for Microsoft SQL Server. The validator implements all the checks discussed in the earlier article. The downloadable source code can be found at the end of this article.
Continue reading
