Advertisement

ETL Basics

  • Albert Nogués
  • Juan Valladares
Chapter

Abstract

In the previous chapter, we developed our datawarehouse model. This was the first chapter that we get our hands on our solution. It is very important to have a correct understanding of that chapter and be familiar with the model in order to consolidate this knowledge that we will acquire for the next set of chapters, as we will have to build upon it. In Business Intelligence, usually we talk about three areas: Database and Datawarehouse design, ETL, and Reporting. We covered the first one, and are now we are just ahead of starting the second one. In this ETL chapter we will see how to Extract, Transform, and Load process the data into our datawarehouse. Let's start!

Keywords

Fact Table Staging Area Output Step Database Connection Staging Table 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Albert Nogués and Juan Valladares 2017

Authors and Affiliations

  • Albert Nogués
    • 1
  • Juan Valladares
    • 1
  1. 1.BarcelonaSpain

Personalised recommendations