Chapter 8, Working with Databases
Pop quiz – connecting to a database in several transformations
|
Q1 |
3 |
Pop quiz – interpreting data types coming from a database
|
Q1 |
2 |
Pop quiz – interpreting data types coming from a database
|
Q1 |
1 If an incoming row belongs to a product that doesn't exist in the products table, both the Insert/Update step and the Table output step will insert the record. If an incoming row belongs to a product that already exist in the products table, the Insert/Update step updates it. In this alternative version, the Table output will fail (there cannot be two products with the same value for the primary key), but the failing row goes to the Update step that updates the record. If an incoming row contains invalid data (for example, ... |
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.
