-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Pentaho Data Integration 4 Cookbook

The Database join step that you learned to use in the previous recipe is quite powerful and has several advantages over the simple Database lookup step. There is a still more powerful step for searching in a database: The Dynamic SQL row step. This recipe explains to you its capabilities and shows you how to use it.
In order to let you compare the different options for searching in a database with ease, we will work with an example similar to that you saw in the previous two recipes: we will work with the Steel Wheels sample data. You want to look for the following products:
Products that contain Aston Martin
in their description
Products that contain Ford Falcon
in their name and with scale 1:18
Products that contain Corvette
in their name and with scale 1:24
In order to follow this recipe, you need the Steel Wheels database.
Carry out the following steps:
Create a new transformation.
Create a stream that generates...
Change the font size
Change margin width
Change background colour