Designing a Data Flow

A data flow contains the parameters for extracting information from data sources and loading it into data targets. You create data flows in the Data Management Console using the data flow workspace.

Typically, you build a data flow from a set of objects that identify data sources, data targets, data columns to include, and business rules governing how data is extracted, transformed, and loaded to form a data warehouse, data mart, or any other type of target.

You can join multiple data sources, filter and sort the extracted source data, and specify column mappings from the source to the target.

You can also create specialized data flows, such as Direct Load and DBMS SQL flows.

This chapter describes how to design and create the different kinds of data flows.

iWay Software