Data Warehouse and allocated cost data
tom
In a previous post, I showed that costs data may be allocated to other departments or levels of granularity to enable cost analysis. The allocated cost data are artificial data:…
Cost Allocation
In most organisations, cost data are collected on a different level of granularity or attached to another dimension as we would like to see the cost data. Two examples. Cost…
A script to create a sample data warehouse – part 2 the fact
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…
A script to create a sample data warehouse – part 1 the dimension
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…
Free ETL tool
Yesterday evening, I received a copy of Expressor. This is a free ETL tool which made a very good impression to me. I downloaded the copy from http://www.expressor-software.com . The…
Bugzilla
In the test phase, we would like to create a nice list of encountered bugs. In most situations a project assistant is given the task to maintain this list. All…
Deferring referential integrity constraints
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…
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…
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…