Summary
In this chapter, you learned to perform some advanced operations on databases. Firstly, you populated the Jigsaw database in order to have data for the activities in the chapter. Then, you learned how to do simple and complex searches in a database.
After that, you were introduced to dimensional concepts, learned what dimensions are, and how to load them with PDI. You learned about Type I, Type II, Type III SCDs, and mini dimensions. You still have to learn when and how to use those dimensions. You will do so in Chapter 12, Developing and Implementing a Simple Datamart.
The steps you learned in this and the last chapter are far from being the full list of steps that PDI offers to work with databases. However, taking into account all that you learned, you are now ready to use PDI for implementing most of your database requirements.
In the next chapter, you will switch to a very different yet core subject needed to work with PDI: jobs.
