CDW Most Frequently Asked Latest Pentaho Interview Questions Answers

Wha Is Xml?

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.

How To Use Database Connections From Repository?

You can either create a new transformation/job or close and reopen the ones already loaded in Spoon.

Explain In Brief The Concept Pentaho Dashboard.?

Dashboards are the collection of various information objects on single page including diagrams, tables and textual information. The Pentaho AJAX API is used to extract BI information while Pentaho Solution Repository contains the content definitions.

The steps involved in Dashboard creation include:

Adding dashboard to the solution.
Defining dashboard content.
Implementing filters.
Editing dashboards.

CDW Most Frequently Asked Latest Pentaho Interview Questions Answers

How To Use Logic From One Transformation/job In Other Process?

Transformation logic can be shared using subtransformations, which provides seamless loading and transformation of variables enhancing efficiency and productivity of the system. Subtransformations can be called and reconfigured when required.

Explain The Use Of Pentaho Reporting.?

Pentaho reporting enables businesses to create structured and informative reports to easily access, format and deliver meaningful and important information to clients and customers. They also help business users to analyze and track consumer behavior for the specific time and functionality, thereby directing them towards the right success path.

What Is Pentaho Data Mining?

Pentaho Data Mining refers to the Weka Project, which consists of a detailed tool set for machine learning and data mining. Weka is open source software for extracting large sers of information about users, clients and businesses. It is built on Java programming.

Is Data Integration And Etl Programming Same?

No. Data Integration refers to passing of data from one type of systems to other within the same application. On the contrary, ETL is used to extract and access data from different sources. And transform it into other objects and tables.

Explain Hierarchy Flattening.?

It is just the construction of parent child relationships in a database. Hierarchy Flattening uses both horizontal and vertical formats, which enables easy and trouble-free identification of sub elements. It further allows users to understand and read the main hierarchy of BI and includes Parent column, Child Column, Parent attributes and Child attributes.

Define Pentaho Bi Project?

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.

What Major Applications Comprises Of Pentaho Bi Project?

The Pentaho BI Project encompasses the following major application areas:

Business Intelligence Platform
Data Mining
Reporting
Dashboards
Business Intelligence Platform

Which Platform Benefits From The Pentaho Bi Project?

Java developers who generally use project components to rapidly assemble custom BI solutions
ISVs who can improve the value and ability of their solutions by embedding BI functionality
End-Users who can quickly deploy packaged BI solutions which are either modest or greater to traditional commercial offerings at a dramatically lower cost.

Explain Pentaho?

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.

What Do You Un Derstand By The Term Etl?

It is an entri level tool for data manipulation.

What Do You Understand By Hierarchical Navigation?

A hierarchical navigation menu allows the user to come directly to a section of the site several levels below the top.

What Do You Understand By Three Tier Data Warehouse?

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.

What Are Various Tools In Etl?

Abinitio,DataStage, Informatica, Cognos Decision Stream, etc

How Do You Duplicate A Field In A Row In A Transformation?

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.

Why Can’t I Duplicate Fieldnames In A Single Row?

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.