AWK to investigate files on Unix
tom
Today, I worked with the Unix’ awk utility. This is an extremely potent utility to investigate text files on a Unix platform. It can be invoked from the terminal command…
Hadoop
Everyone talks about big data and Hadoop. Someone even compared it to teenage sex: everone talks about it, everyone knows someone who does it but no-one yet does it. I…
Slowly Changing Dimensions Type 2
Just to get myself acquainted with the new Informatica version, I created a mapping in which SCD 2 was inplemented. The mapping is shown here. In the first step, the…
Use Case, Business Events and Time Events
In a previous post, I showed the context diagramme. I then continued by saying that each of the arrows that flow to and fro the bubble in the middle can…
Access odbc
Just a little note. I discovered that one may access the 32 bit ODBC drivers on a 64 bit platform via: C:\Windows\SysWOW64\odbcad32.exe and the 64 bit ODBC drivers via: C:\Windows\System32\odbcad32.exe…
Use Case
A Use Case is something that can be written after a context diagramme is written. A context diagramme provides an overview of the whole system with its interfaces to the…
Requirements analysis
Recently I read a very interesting book on requirements analysis “Mastering the Requirements Process: Getting Requirements Right” by Suzanne Robertson and James Robertson. They wrote a practical book that lead…
Context diagrammes – understanding a scope
I came accross a very nice technique that can be used to show the scope of a project. It is called the Context Diagramme. The idea is that the system…
Yet another checklist
I often come across checklists. Such checklists are used to assess the quality of, say, a database. See here for an example of such a checklist. In this case, we…
Teradata: what columns to choose as Primary Index?
A major question with Teradata tables is what columns to choose when a primary index must be created. I understand that 4 different arguments might be used: 1: Is the…