Databases Reference
In-Depth Information
5.
We're going to need a number of tables as source data in this job. From the
DEMO_DB
metadata, drop the
products
,
brands
,
orders
, and
order_lines
tables onto the Job Designer, selecting
tMySQLInput
in each case as the
desired component.
6.
Search for
tMap
in the
Palette
window and drop this onto the Job
Designer too.
7.
Right-click on each of the MySQL input components in turn, select
Row | Main,
and connect to the
tMap
component. The table we are
inserting data into contains order data with the
order_id
and
line_id
field as a composite key. Therefore, it makes sense to have either the
orders
or
order_lines
component as the main dataflow into the
tMap
component,
with the others as lookups.
8.
To make things a little easier to understand within the
tMap
component, it is
worth taking a moment to rename the dataflows. You can do this by double-
clicking on the
row1
name. This will make the label editable. Change
row1
to
order_lines
and do the same for
row2
,
row3
, and
row4
, changing the name
to match the database table each dataflow is coming from.
9.
Now double-click on the
tMap
component to open the Map Editor, where we
can join the incoming dataflows.
Search WWH ::
Custom Search