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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
I am subscribed to several blogs. One such blog is a blog from Dylan Jones that is maintained from the “Data Quality Pro community”. From this blog I got the…