Deferring referential integrity constraints
tom
Last week, I gave a course on data warehousing. When I overviewed the theory, I noticed I had to spend some time on “disabling the the referential integrity constraints”. I…
Temporary tables in Oracle
Oracle has a feature it is possible to create tamporary tables. The idea is that a table can be created, can be populated with data, but these data can only…
Creating a cookie
Cookies are small items that can be written on the hard disk of a client computer. In Google Chrome, these cookies can be found in a binary file. I found…
How to run a SAS job in a batch mode
I hope you recognise the situation. You have developed some SAS code (in Enterprise Guide, SAS Base Editor or DI Studio) and you would like to create a batch job…
OLE DB
Today, I tried to link a ODBC compliant database to a SAS programme. SAS is a programme, much like Perl, that allows data to be read, transformed and written back…
The tragedy of not usings dates
I now work with a financial institute where they took the decision NOT to use date formats for data-values. This meant that they use 20110310 to indicate the 10th March…
Run ODBC
In some environments, the possibility to create an ODBC link is prohibited. Due to misunderstood security issues, the creation of an ODBC link is not permitted. But is might be…
Create a surrogate key in Oracle
To create a surrogate key in Oracle is not really trivial. The issue, we address works as follows. Assume we have a table with 3 records an four attributes. The…
send mail via telnet
I am subscribed to a ADSL provider who also provides Email services. Hence, I could try to send some mail from the command line on my laptop. As a first…
Create my own data warehouse
I had the time to create a small example data warehouse. As sourcing system, I used the Northwind database. This is an example database that is provided by Microsoft. It…