What to shift your career to Pentaho BI? Then we have provided you with the complete details about the Pentaho BI Interview Question and Answers on our site page. Carking an interview at very first attempt need very hard working and should have a good knowledge on all concepts as well. Pentaho is a business intelligence (BI) software that offers data integration, OLAP services, broadcasting, information dashboards, data mining and abstract, transform, load (ETL) capabilities. If you are good at the Pentaho BI concepts then there are various companies that offer job roles like Enterprise ETL Engineer, Application Developer, BI Developer, Software Developer and many other roles too. For any other further details on Pentaho BI jobs visit our site www.wisdomjobs.com.
Answer :
It addresses the blockades that block the organization’s ability to get value from all our data. Pentaho is discovered to ensure that each member of our team from developers to business users can easily convert data into value.
Question 2. Mention Major Features Of Pentaho?
Answer :
Direct Analytics on MongoDB: It authorizes business analysts and IT to access, analyze, and visualize MongoDB data.
Science Pack: Pentaho’s Data Science Pack operationalizes analytical modeling and machine learning while allowing data scientists and developers to unburden the labor of data preparation to Pentaho Data Integration.
Full YARN Support for Hadoop: Pentaho’s YARN mixing enables organizations to exploit the full computing power of Hadoop while leveraging existing skillsets and technology investments.
Question 3. Define Pentaho Bi Project?
Answer :
The Pentaho BI Project is an current effort by the Open Source communal to provide groups with best-in-class solutions for their initiative Business Intelligence (BI) needs.
Question 4. What Major Applications Comprises Of Pentaho Bi Project?
Answer :
The Pentaho BI Project encompasses the following major application areas:
Question 5. Which Platform Benefits From The Pentaho Bi Project?
Answer :
Question 6. Is Pentaho A Trademark?
Answer :
Yes, Pentaho is a trademark.
Question 7. What Do You Understand By Pentaho Metadata?
Answer :
Pentaho Metadata is a piece of the Pentaho BI Platform designed to make it easier for users to access information in business terms.
Question 8. How Does Pentaho Metadata Work?
Answer :
With the help of Pentaho’s open source metadata capabilities, administrators can outline a layer of abstraction that presents database information to business users in familiar business terms.
Question 9. What Is The Pentaho Reporting Evaluation?
Answer :
Pentaho Reporting Evaluation is a particular package of a subset of the Pentaho Reporting capabilities, designed for typical first-phase evaluation activities such as accessing sample data, creating and editing reports, and viewing and interacting with reports.
Answer :
Multidimensional Expressions (MDX) is a query language for OLAP databases, much like SQL is a query language for relational databases. It is also a calculation language, with syntax similar to spreadsheet formulas.
Answer :
Finite ordered list of elements is called as tuple.
Question 12. What Kind Of Data, Cube Contain?
Answer :
The Cube will contain the following data:
Question 13. Differentiate Between Transformations And Jobs?
Answer :
Question 14. How To Do A Database Join With Pdi?
Answer :
Question 15. How To Sequentialize Transformations?
Answer :
it is not possible as in PDI transformations all of the steps run in parallel. So we can’t sequentialize them.
Question 16. How We Can Use Database Connections From Repository?
Answer :
We can Create a new conversion or close and re-open the ones we have loaded in Spoon.
Answer :
BIT is not a standard SQL data type. It’s not even standard on MySQL as the meaning (core definition) changed from MySQL version 4 to 5.
Also a BIT uses 2 bytes on MySQL. That’s why in PDI we made the safe choice and went for a char(1) to store a boolean. There is a simple workaround available: change the data type with a Select Values step to “Integer” in the metadata tab. This converts it to 1 for “true” and 0 for “false”, just like MySQL expects.
Answer :
This is not possible as in PDI transformations all the steps run in parallel. So we can’t sequentialize them. This would require architectural changes to PDI and sequential processing also result in very slow processing.
Question 19. Why Can’t We Duplicate Fieldnames In A Single Row?
Answer :
we can’t. if we have duplicate fieldnames. Before PDI v2.5.0 we were able to force duplicate fields, but also only the first value of the duplicate fields could ever be used.
Question 20. What Are The Benefits Of Pentaho?
Answer :
1. Open Source
2. Have community that support the users
3. Running well under multi platform (Windows, Linux, Macintosh, Solaris, Unix, etc)
4. Have complete package from reporting, ETL for warehousing data management,
5. OLAP server data mining also dashboard.
Question 21. Differentiate Between Arguments And Variables?
Answer :
Arguments are command line arguments that we would normally specify during batch processing .
Variables are environment or PDI variables that we would normally set in a previous transformation in a job.
Question 22. What Are The Applications Of Pentaho?
Answer :
1. Suite Pentaho
2. All build under Java platform
Question 23. What Do You Understand By The Term Pentaho Dashboard?
Answer :
Pentaho Dashboards give business users the critical information they need to understand and improve organizational performance.
Question 24. What Is The Use Of Pentaho Reporting?
Answer :
Pentaho Reporting allows organizations to easily access, format and deliver information to employees, customers and partners.
Question 25. Define Pentaho Schema Workbench?
Answer :
Pentaho Schema Workbench offers a graphical edge for designing OLAP cubes for Pentaho Analysis.
Question 26. Define Pentho Data Mining?
Answer :
Pentaho Data Mining used the Waikato Environment for Information Analysis to search data for patterns. It have functions for data processing, regression analysis, classification methods, etc.
Question 27. Brief About Pentaho Report Designer?
Answer :
It is a visual, banded report writer. It has various features lilke using subreports, charts and graphs etc.
Question 28. What Do You Un Derstand By The Term Etl?
Answer :
It is an entri level tool for data manipulation.
Question 29. What Do You Understand By Hierarchical Navigation?
Answer :
A hierarchical navigation menu allows the user to come directly to a section of the site several levels below the top.
Question 30. What Are The Steps To Decrypt A Folder Or File?
Answer :
Question 31. Explain Encrypting File System?
Answer :
It is the technology which enables files to be transparently encrypted to secure personal data from attackers with physical access to the computer.
Question 32. What Do You Mean By Repository?
Answer :
Repository is a storage location where we can store the data safely without any harmness.
Question 33. Explain Why We Need Etl Tool?
Answer :
ETL Tool is used to get data from many source system like RDBMS, SAP, etc. and convert them based on the user requirement. It is required when data float across many systems.
Question 34. What Is Etl Process? Write The Steps Also?
Answer :
ETL is extraction , transforming , loading process the steps are :
1 – define the source
2 – define the target
3 – create the mapping
4 – create the session
5 – create the work flow
Question 35. What Is Metadata?
Answer :
The metadata stored in the repository by associating information with individual objects in the repository.
Question 36. What Are Snapshots?
Answer :
Snapshots are read-only copies of a master table located on a remote node which can be periodically refreshed to reflect changes made to the master table.
Question 37. What Is Data Staging?
Answer :
Data staging is actually a group of procedures used to prepare source system data for loading a data warehouse.
Answer :
Answer :
Dataflow from source to target is called as mapping.
Answer :
It is a set of instruction which tell when and how to move data from respective source to target.
Question 41. What Is Workflow?
Answer :
It is a set of instruction which tell the infomatica server how to execute the task.
Answer :
It creates and configure the set of transformation.
Question 43. What Do You Understand By Three Tier Data Warehouse?
Answer :
A data warehouse is said to be a three-tier system where a middle system provides usable data in a secure way to end users. Both side of this middle system are the end users and the back-end data stores.
Answer :
ODS is Operational Data Store which comes in between of data warehouse and staging area.
Question 45. Differentiate Between Etl Tool And Olap Tool?
Answer :
ETL Tool is used for extracting data from the legecy system and load it into specified database with some processing of cleansing data.
OLAP Tool is used for reporting process . Here data is available in multidimensional model hence we can write simple query to extract data from database.
Answer :
XML is an extensiable markup language which defines a set of rule for encoding documents in both formats which is human readable and machine readable.
Question 47. What Are Various Tools In Etl?
Answer :
Abinitio,DataStage, Informatica, Cognos Decision Stream, etc
Answer :
MDX is multi- dimensional expression which is a main query language implemented by the Mondrains.
Question 49. Define Multi-dimensional Cube?
Answer :
It is a cube to view data where we can slice and dice the data. It have time dimension, locations and figures.
Question 50. How Do You Duplicate A Field In A Row In A Transformation?
Answer :
Several solutions exist:
Use a “Select Values” step renaming a field while selecting also the original one. The result will be that the original field will be duplicated to another name.
It will look as follows:
This will duplicate fieldA to fieldB and fieldC.
Use a calculator step and use e.g. The NLV(A,B) operation as follows:
This will have the same effect as the first solution: 3 fields in the output which are copies of each other: fieldA, fieldB, and fieldC.
Use a JavaScript step to copy the field:
This will have the same effect as the previous solutions: 3 fields in the output which are copies of each other: fieldA, fieldB, and fieldC.
Question 51. Why Can’t I Duplicate Fieldnames In A Single Row?
Answer :
You can’t. PDI will complain in most of the cases if you have duplicate fieldnames. Before PDI v2.5.0 you were able to force duplicate fields, but also only the first value of the duplicate fields could ever be used.
Answer :
Transformations stream data through their steps:
Answer :
If you look in the PDI main directory you will see a sub-directory “simple-jndi”, which contains a file called “jdbc.properties”. You should change this file so that the JNDI information matches the one you use in your application server.
After that you set in the connection tab of Spoon the “Method of access” to JNDI, the “Connection type” to the type of database you’re using. And “Connection name” to the name of the JDNI datasource (as used in “jdbc.properties”).
Pentaho BI Related Tutorials |
|
---|---|
Informatica Tutorial | ETL Testing Tutorial |
Data Warehouse ETL Toolkit Tutorial | Pentaho Tutorial |
Pentaho BI Related Practice Tests |
|
---|---|
Informatica Practice Tests | ETL Testing Practice Tests |
Ibm Tivoli Netcool Omnibus Practice Tests |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.