Today, i will share few set of interview questions on Pentaho. Below are the Questions.
- How you will implement SCD type 0 ,SCD type 1, SCD type 2 in pentaho.
- Difference between arguments and variables
- What are the components present in transformation, name at least 10 components.
- Have you ever implemented any plugin using Java in Pentaho.
- If I want to run 10 jobs in parallel through Shell Script, how should I do it.
- What is factless fact table , give practical examples
- What is conformed dimension and degenerate dimensions
- Difference between Database join and sql script
- How you will design ETL if the Usecase fails , then in case of rerun it should run from start of failure
- How you implement Exceptional handling in your Pentaho Project
- If I have different date format values , how will convert them into single format and load into tables
- How you will lookup the data from the table without using the table lookup
- How have you handled incremental loading in your project using Pentaho
- Have you faced any issues in Pentaho regarding performance. If yes how you have resolved that issue.
- What is the biggest Challange have you faced while designing ETL Usecase.
- What is partitioning in Pentaho and how will you implement the same.