Understanding the PDI rowset

Transformation deal with datasets or rowsets, that is, rows of data with a predefined metadata. The metadata tells us about the structure of data, that is, the list of fields as well as their definitions. The following table describes the metadata of a PDI dataset:

Metadata Element

Description

Field name

Name of the field; it can be any (not null) text

Type

One of the supported types, as, for example, String or Integer

Length

Length of the field

Precision

Applicable for numeric fields

Position

Position of the field relative to the other fields, starting at 1

 

These metadata concepts shouldn't be new to you. Let's look at some examples:

  • Recall the Hello World Transformation. ...

Get Learning Pentaho Data Integration 8 CE - Third Edition 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.