In this chapter, we will explain how to save transformation output in files and relational databases. In addition, we will cover how to load data into a datamart.
The following topics will be covered in this chapter:
- Generating different kinds of files
- Inserting and updating data into database tables
- Loading dimensions
- Loading fact tables