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

 

3 comments :

Unknown 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

john said...

Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai

Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.

Spring Training in Chennai

The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

Post a Comment

UA-46724997-1