Designing data flows

You can design a data flow to model SQL-based data movement and transformation by placing operators in a canvas, defining their properties, and connecting their ports. A data flow is the basic structure for designing applications with the SQL Warehousing Tool. Several data flows under a single control flow make up a typical data warehousing application that you can deploy and run.

Before you begin

Before you begin

Ensure that the Design Studio is open in the Data Warehousing perspective, you have created a data warehousing project, and you have access to a physical data model (metadata for your source and target tables).

About this task

Procedure

To learn about the steps for creating a data flow, see the following topics: