Leveraging DB2 10 for High Performance of Your Data Warehouse

Data movement and transformation

This chapter provides information about some of the commonly used utilities in DB2 for Linux, UNIX, and Windows tools that are used for data movement. This chapter also describes the data movement and transformation capabilities in DB2 Warehouse SQL Warehousing Tool (SQW) that provides these services.

6.1 Introduction

Moving data across different databases is a common task in IT departments. Moving data mainly refers to the task of copying data from a source system to a target system, not necessarily removing it ...