Aside from performing CRUD operations, PDI can be used to load datamarts. In order to demonstrate how PDI can help you to do so, we will populate a very simple datamart.
This is just a quick overview of the subject. We assume that you have at least a basic understanding of datawarehouse concepts (for example, dimensions, time dimensions, SCD, and fact tables).
The source data will be the Sports database. We will have a simple fact table and just three dimensions, as shown in the next diagram:
Injuries datamart
The fact table will keep track of the injuries suffered by sport players. This fact table will have just one measure: the quantity of injuries.
The dimensions involved in this datamart will be as follows:
- A time dimension, for the injury date
- A body parts dimension, with the name of the injured body part
- A person dimension, with the name of the...
