Skewness in teradata
Currently, I work on a Teradata machine. I understand that Teradata is based on the idea that processes work in parallel with each other. The idea is that data are…
Currently, I work on a Teradata machine. I understand that Teradata is based on the idea that processes work in parallel with each other. The idea is that data are…
There exist many ways to get data from Oracle. After all, this is the core functionality of Oracle: getting data in and out. A nice possibility is to retrieve data…
Oracle has introduced a small version of its DBMS that is labelled “XE”. This small version can be downloaded and used for free upon the condition that its usage is…
In Oracle, it is quite well possible to display quickly how many non-nulls we have per column in a table. The script reads like: set termout off echo on feed…
Recently, I encountered a very nice script that allows us to get an overview of the number of records per table in an Oracle scheme. First the script: set termout…
Today, I heard someone complaining that he received a file that contained “unexpected characters”. Later it was discovered that this file was provided in EBCDIC and the receiver tried to…
I have created an example data warehouse with just one dimension table and one fact table. We have discussed how the dimension table must be loaded. Once the dimension table…
In the last week, I have written a sample script to create a skeleton data warehouse. I will use this as a head start for future work where the skeleton…