Business Intelligence Passing Parameters in Pentaho Data Integration Part 1 By Nikhilesh Passing Parameters From Parent Job to Sub-Job/Transformation in Pentaho Data Integration (Kettle) - Part 1 Part -1 : Using setter and getter methods : 1.Set variables in parent job/transformation. 2.Get variables in sub-job/transformation. Make data easy with Helical Insight. Helical...
Business Intelligence Passing parameters in Pentaho Data Integration Part 2 By Nikhilesh Passing Parameters From Parent Job to Sub Job/Transformation in Pentaho Data Integration (Kettle) -Part 2 In part 1, I have mentioned about passing parameter values down to sub-job/transformation using setter/getter methods. Please refer my previous post for part 1 Passing...
Business Intelligence Command Line Execution and Redirection Process in Pentaho (Kettle) By Nikhilesh Command line execution in Pentaho (Kettle) : Pentaho provides two command line utility tools to execute your job/transformation from outside of spoon. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab...
Business Intelligence Implementing Loops in Pentaho Data Integration By Nikhilesh Issues while implementing loops in Pentaho Data Integration Generally for implementing batch processing we use the looping concept provided by Pentaho in their ETL jobs. The loops in PDI are supported only on jobs(kjb) and it is not supported in...
Business Intelligence Batch Process Implementation in Kettle By Nikhilesh Batch Process Implementation in Kettle (Pentaho Data Integration) In order to implement the batch process we needs to have the looping logic. But I did not find any component or suitable method in kettle to create those loops. Make data...
Pentaho Handling Null values in Talend and Pentaho By Nikhilesh Handling Null values in Talend and Pentaho Handling Null values in Talend: Make all the columns as Nullable in tMap Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30...
Business Intelligence Slowly Changing Dimension in Pentaho Data Integration(Kettle) By Nikhilesh Slowly Changing Dimension in Pentaho Data Integration(Kettle) Slowly changing dimension(SCD) is a common mechanism in Datawarehousing concepts. The exact definition of SCD is the dimension that changes slowly over a time rather than on a regular schedule. In Data Warehouse...
Business Intelligence Looping and Batch Processing in PDI By Nikhilesh Implementing Loops and batch processing in Kettle What is batch processing? Batch processing is basically a series of execution of jobs from source to destination. Here the data is divided into smaller batches and transferred to the destination. This helps...
Business Intelligence Pentaho Analysis: Workflow By Nikhilesh OLAP Analysis: Workflow To prepare data for use with the Pentaho/Jaspersoft OLAP Analysis (and Reporting, to a certain extent) client tools, you should follow this basic workflow : Design a Star or Snowflake Schema The entire process starts with a...
Business Intelligence Audit Logs in Pentaho Data Integration (PDI) By Nikhilesh Audit Logs in Pentaho Data Integration Audit Logs at Job level and Transformation Level are very useful for ETL projects to track the details regarding Job name, Start Date, End Date, Transformation Name, Error,Number of Lines Read, Number of Line Write,...
Business Intelligence Migrate Oracle with Pentaho By Nikhilesh Steps to migrate Oracle with Pentaho Step 1:- Run the script as DB admin. Script is available in location:- biserver-ce\data\oracle10g. Modify configuration file:- applicationContext-spring-security-hibernate.properties. Location:- pentaho-solutions\system\applicationContext-spring-security-hibernate.properties. original code:- jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb: hsql:// localhost:9001/ hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.HSQLDialect Modified code:- dbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521/sysdba...
Business Intelligence Table Expansion in Pentaho CDE By Nikhilesh Hello, we are now working on Table Expansion property of Pentaho CDE. Simple, expanding a Main Table on click and render relevant data in Any Chart / table. Make data easy with Helical Insight. Helical Insight is the world's best...