However, the transformation techniques introduced in this chapter meet the majority of real-world data transformation requirements, often with more scalability and less programming than alternative approaches.
Real-world data transformations are often considerably more complex. The examples in this chapter are relatively simple.
This chapter introduces techniques for implementing scalable and efficient data transformations within the Oracle Database. Many, if not all, data transformations can occur within an Oracle database, although transformations are often implemented outside of the database (for example, on flat files) as well. They can range from simple data conversions to extremely complex data scrubbing techniques. Data transformations are often the most complex and, in terms of processing time, the most costly part of the extraction, transformation, and loading (ETL) process.
0 kommentar(er)
