Transformation and Job in Pentaho

It is often consider to arrange your work around transformation in a single or more than one jobbut to complete all tasks in one transformation is not suitable and not result oriented. it is recommended that first open a job put transformations as required and then complete step by step executi...

read more

Environment Variables Declaration in Pentaho

To have a common access for specific variables all around your transformations you can declarethem as Environment variables.following are the stepsfirst name the variableset default values for the variableto get access these variables in your desired transformation pick a Get Variable icon from menu and drag it to you desired transformation.name the variable and select environment variable from the drop down combonow you can access these variables either in your input step or the SQL script step...

read more

SQL Quiries

Learn Database quires and become database Engin...

read more