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!!

 

2 comments :

Thamarai Ravi said...

This blog explains the details of most popular technological details. This helps to learn about what are all the different method is there. And the working methods all of that are explained here. Informative blog.
Digital Marketing Course in Chennai

Aditi Ray said...

TreasureBox is operated by a group of young, passionate, and ambitious people that are working diligently towards the same goal - make your every dollar count, as we believe you deserve something better.
bedroom furniture nz
pregnancy pillow nz
chicken coops nz

Post a Comment

UA-46724997-1