Extracts from multiple tables
The previous extract example was based on data from a single table, but we frequently need to retrieve data from multiple tables in a denormalized form. Most modern applications that use a relational database will have a normalized structure, so, by definition, extracting data in a denormalized form will involve joining data from different tables.
In the Studio, we can join the data within the database extract component, using the database itself to do the work or outside of a component, within the job, where it is Java that does the data crunching. Let's take a look at examples of both.
Joining within the database component
Our first example is straightforward and presents an SQL query to the database component that ...
Get Getting Started with Talend Open Studio for Data Integration 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.
