
351
13
Data Loading
This chapter examines the loading of data into an Oracle Database data
warehouse. There are various ways in which the loading process can be
made to perform better. This chapter will attempt to focus on the perfor-
mance aspects of what is effectively a three-step process, and sometimes
even a four-step process, including extraction, transportation, transforma-
tion, and loading processes. I like to add an extra definitional step to the
loading process, called transportation. Transportation methods will also be
discussed in this chapter, because some methods are better and faster than
others and there are some very specific and highly ...