Join Data Sources
There are two data sources CUSTOMERS
and the output of AggregateSALES
.
Use a Join node to combine these two data sources into one data source.
A Join combines rows from two or more tables, views, or materialized views. The join can select any columns from any of the tables being combined.
In this cue card set we create an inner join. An inner join (sometimes called a simple join) is a join of two or more tables that
returns only those rows that satisfy the join condition.
After the you define and execute the join, the workflow looks like:
Copyright © 2011, 2012, Oracle. All rights reserved.