DataMigrator/Reporting Server > Designing a Data Flow > Adding a SELECT to a Data Flow

Adding a SELECT to a Data Flow

How to:

Adding a SELECT to a data flow lets you add a subselect, a select within a select. A subselect, also called a subquery, allows you to use the results of one select as part of another select. While subselects can be used in different places in the SQL language, adding a select to a data flow lets you use a select statement as a source, for example, to join to an aggregated or filtered selection from a table. By using a subselect, the need for intermediate staging tables can be avoided.

Procedure: How to Add a SELECT to a Data Flow

From the data flow workspace:

  1. Right-click to the left of the SQL object and click Add Select.

    or

    Right-click a SQL, Join, or Union object, point to Add, and then click Select.

  2. A new SQL object appears in the data flow. Right-click the object, point to Add, and then click another object type.
  3. Continue to build the data flow.

 WebFOCUS

Feedback