Before getting into the details of building a data mart with PDI, we will perform the following:
- Present the data that will be used for all the tutorials and examples through the rest of the chapter
- Create and populate the database so that it's ready to run the tutorials
The following information allows you to understand the organization of the data in our sample Jigsaw
database. In the first place, you have the entity relationship diagram (ERD) for the js
database:
ERD for the Jigsaw database
The following table contains a brief explanation of what each table is for:
Table | Content |
---|---|
| Information about manufacturers of the products. |
| It contains information about products such as puzzles and accessories. The table has descriptive information and data about prices and stock. The |
|