Data Warehouse and allocated cost data
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:…
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:…
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…
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…
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…
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…
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…
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…
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…
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…