Looking up data in a database
You already know how to create, update, and delete data from a database. It's time to learn how to look up data. Let's call lookup as the act of searching information in a database. You can lookup a column of a single table or you can do more complex lookups. Let's begin with the simplest way of looking up.
Doing simple lookups
Sometimes you need to get information from a database table based on data you have in your main stream. Let's see how you do it.
Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
