O'Reilly logo

Oracle SQL Recipes: A Problem-Solution Approach by Darl Kuhn, Bob Bryla, Grant Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Cleansing Data

Occasionally you'll find yourself working in environments where you are extracting information from some data source and importing it into a relational database. The source of the information could be spreadsheets, CSV files, other databases, and so on. For example, it's common in data warehouse environments to take data from several different database sources and import it into a centralized reporting database.

When moving data from one source to another, there are sometimes conversion issues if the source data types are different from the target data types. In these situations, you'll have to check the source data to make sure it is loadable into the destination database. For example, you could have a character string ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required