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 ...
Get Oracle SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
