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
Category Archives: Data Warehousing
Data Modeling Zone 2013
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!
Preparing TDWI Session
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.
Week in Review
Over the Christmas season and New Year break, I have been working on my blog www.dwhwiki.info.
Continue reading
Data Vault @ HS Hannover
Just went to a session at the HS Hannover, got clicked…
#Pentaho Client for #Android & #iPhone
Nice: a mobile client for Pentaho BI is available:
Continue reading
Member Code Already Used by a Deleted Member in #MDS of #SQLServer
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
ISO 3166 Country Codes for #DWH #BI
A list of country codes, especially interesting for data warehousing projects:
Continue reading
Skip Trailing Blanks of Fixed Length Files in #Informatica
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
Vehicle Identification Number (VIN) Validator for #SQLServer
#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