Today, I will share few more set of questions that can be asked in Pentaho DI Interview.

1. How you will merge the rows in one row based with delimiter as separator in Pentaho
2. How to split the row into multiple rows having delimiter in it using Pentaho DI.
3. Scenario Based Question

We have three csv files with Data as below
File1.txt
A B C
1 2 3
1 3 1
1 1 3

File2.txt
A B C
1 2 1
2 1 1
1 3 1

File3.txt
A B C
1 1 1
3 1 2
1 1 1

Output should be like below

File1.txt
A B C D
1 2 3 1
1 3 1 1
1 1 3 1

File2.txt
A B C D
1 2 1 2
2 1 1 2
1 3 1 2

File3.txt
A B C D
1 1 1 3
3 1 2 3
1 1 1 3

4. How to check the existence of a file and then resume the ETL code . The file has date part as well.Hence you need a wildcard as well.
5. How “Detect Empty Stream” Works in Pentaho. Where all we can use this component?.
6. If you need to run the same code multiple times based on the number of records coming as stream, how you will design the job?
7. What is the component name in job and transformation which will filter out records and evaluates to TRUE or FALSE.
8. What is the difference between count(1) and count(col_name) in oracle?
9. Similarities between where and having clause in Oracle.
10. We have one component “create folder” , why we need to use this component as folder creation will be done at the beginning before we even start coding.