Pentaho Data Integration - Data Grid Input step

This step generally used for testing, reference or demo purposes. We can create a static rows in a grid.

• Meta tab : Enter field names and meta data info.
• Data tab : Enter static data in a grid.

Here are the step wise illustrations on how to use Data Grid step.

Step 1 

Create a demo transformation and drag "Data Grid" input step into the canvas.

Step 2

Meta data information - Enter name, type, format, precision e.t.c.

Step 3

Click on data tab - Enter static rows into the grid.

Step 4
Drag a dummy step and complete the transformation flow ( for demo purpose ) .

Step 5
Execution results.

Preview Data

Execution Log

trf_Demo_Load_DataGrid_File - Transformation is pre-loaded.
Spoon - Transformation opened.
Spoon - Launching transformation [trf_Demo_Load_DataGrid_File]...
Spoon - Started the transformation execution.
trf_Demo_Load_DataGrid_File - Dispatching started for transformation [trf_Demo_Load_DataGrid_File]
trf_Demo_Load_DataGrid_File - Nr of arguments detected:0
trf_Demo_Load_DataGrid_File - This is not a replay transformation
trf_Demo_Load_DataGrid_File - I found 2 different steps to launch.
trf_Demo_Load_DataGrid_File - Allocating rowsets...
trf_Demo_Load_DataGrid_File -  Allocating rowsets for step 0 --> Data Grid
trf_Demo_Load_DataGrid_File -   prevcopies = 1, nextcopies=1
trf_Demo_Load_DataGrid_File - Transformation allocated new rowset [Data Grid.0 - Dummy (do nothing).0]
trf_Demo_Load_DataGrid_File -  Allocated 1 rowsets for step 0 --> Data Grid
trf_Demo_Load_DataGrid_File -  Allocating rowsets for step 1 --> Dummy (do nothing)
trf_Demo_Load_DataGrid_File -  Allocated 1 rowsets for step 1 --> Dummy (do nothing)
trf_Demo_Load_DataGrid_File - Allocating Steps & StepData...
trf_Demo_Load_DataGrid_File -  Transformation is about to allocate step [Data Grid] of type [DataGrid]
Data Grid.0 - distribution activated
Data Grid.0 - Starting allocation of buffers & new threads...
Data Grid.0 - Step info: nrinput=0 nroutput=1
Data Grid.0 - output rel. is  1:1
Data Grid.0 - Found output rowset [Data Grid.0 - Dummy (do nothing).0]
Data Grid.0 - Finished dispatching
trf_Demo_Load_DataGrid_File -  Transformation has allocated a new step: [Data Grid].0
trf_Demo_Load_DataGrid_File -  Transformation is about to allocate step [Dummy (do nothing)] of type [Dummy]
Dummy (do nothing).0 - distribution activated
Dummy (do nothing).0 - Starting allocation of buffers & new threads...
Dummy (do nothing).0 - Step info: nrinput=1 nroutput=0
Dummy (do nothing).0 - Got previous step from [Dummy (do nothing)] #0 --> Data Grid
Dummy (do nothing).0 - input rel is 1:1
Dummy (do nothing).0 - Found input rowset [Data Grid.0 - Dummy (do nothing).0]
Dummy (do nothing).0 - Finished dispatching
trf_Demo_Load_DataGrid_File -  Transformation has allocated a new step: [Dummy (do nothing)].0
trf_Demo_Load_DataGrid_File - This transformation can be replayed with replay date: 2015/09/19 21:35:20
trf_Demo_Load_DataGrid_File - Initialising 2 steps...
Data Grid.0 - Released server socket on port 0
Dummy (do nothing).0 - Released server socket on port 0
trf_Demo_Load_DataGrid_File - Step [Data Grid.0] initialized flawlessly.
trf_Demo_Load_DataGrid_File - Step [Dummy (do nothing).0] initialized flawlessly.
trf_Demo_Load_DataGrid_File - Transformation has allocated 2 threads and 1 rowsets.
Data Grid.0 - Starting to run...
Dummy (do nothing).0 - Starting to run...
Data Grid.0 - Finished processing (I=0, O=0, R=0, W=5, U=0, E=0)
Dummy (do nothing).0 - Finished processing (I=0, O=0, R=5, W=5, U=0, E=0)
trf_Demo_Load_DataGrid_File - Handling extension point for plugin with id 'DataRefineryTransFinishListener' and extension point id 'TransformationFinish'
Spoon - The transformation has finished!!