Define Mapplet?
It creates and configure the set of transformation.
What Do You Understand By The Term Pentaho Dashboard?
Pentaho Dashboards give business users the critical information they need to understand and improve organizational performance.
What Is The Use Of Pentaho Reporting?
Pentaho Reporting allows organizations to easily access, format and deliver information to employees, customers and partners.
Define Three Major Types Of Data Integration Jobs.?
Transformation Jobs : Used for preparing data and used only when the there is no change in data until transforming of data job is finished.
Provisioning Jobs : Used for transmission/transfer of large volumes of data. Used only when no change is data is allowed unless job transformation and on large provisioning requirement.
Hybrid Jobs : Execute both transformation and provisioning jobs. No limitations for data changes; it can be updates regardless of success/failure. The transforming and provisioning requirements are not large in this case.
Illustrate The Difference Between Transformations And Jobs.?
While transformations refer to shifting and transforming rows from source system to target system, jobs perform high level operations like implementing transformations, file transfer via FTP, sending mails, etc.
Another significant difference is that the transformation allows parallel execution whereas jobs implement steps in order.
Define Pentaho Report Types.?
There are several categories of Pentaho reports :
Transactional Reports : Data to be used form transactions. Objective is to publish detailed and comprehensive data for day-to-day organization’s activities like purchase orders, sales reporting.
Tactical Reports : data comes from daily or weekly transactional data summary. Objective is to present short-term information for instant decision making like replacing merchandize.
Strategic Reports : data comes from stable and reliable sources to create long-term business information reports like season sales analysis.
Helper Reports : data comes from various resources and includes images, videos to present a variety of activities.
What Are Variables And Arguments In Transformations?
Transformations dialog box consists of two different tables: one of arguments and the other of variables. While arguments refer to command line specified during batch processing, PDI variables refer to objects that are set in a previous transformation/job in the OS.
How To Configure Jndi For Pentaho Di Server?
Pentaho offers JNDI connection configuration for local DI to avoid continuous running of application server during the development and testing of transformations. Edit the properties in jdbc.propertiesfile located at…data-integration-serverpentaho-solutionssystemsimple-jndi.
Explain Pentaho Reporting Evaluation.?
Pentaho Reporting evaluation is a complete package of its reporting abilities, activities and tools, specifically designed for first-phase evaluation like accessing the sample, generating and updating reports, viewing them and performing various interactions. This evaluation consists of Pentaho platform components, Report Designer and ad hoc interface for reporting used for local installation.
Can Field Names In A Row Duplicates In Pentaho?
No, Pentaho doesn’t allow field duplication.
Does Transformation Allow Filed Duplication?
“Select Values” will rename a field as you select the original field also. The original field will have a duplicate name of the other field now.
What Is Ods?
ODS is Operational Data Store which comes in between of data warehouse and staging area.
Differentiate Between Etl Tool And Olap Tool?
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.
Wha Is Xml?
It creates and configure the set of transformation.
What Do You Understand By The Term Pentaho Dashboard?
Pentaho Dashboards give business users the critical information they need to understand and improve organizational performance.
What Is The Use Of Pentaho Reporting?
Pentaho Reporting allows organizations to easily access, format and deliver information to employees, customers and partners.
Transformation Jobs : Used for preparing data and used only when the there is no change in data until transforming of data job is finished.
Provisioning Jobs : Used for transmission/transfer of large volumes of data. Used only when no change is data is allowed unless job transformation and on large provisioning requirement.
Hybrid Jobs : Execute both transformation and provisioning jobs. No limitations for data changes; it can be updates regardless of success/failure. The transforming and provisioning requirements are not large in this case.
 |
| Hitachi Most Frequently Asked Latest Pentaho Interview Questions Answers |
Illustrate The Difference Between Transformations And Jobs.?
While transformations refer to shifting and transforming rows from source system to target system, jobs perform high level operations like implementing transformations, file transfer via FTP, sending mails, etc.
Another significant difference is that the transformation allows parallel execution whereas jobs implement steps in order.
Define Pentaho Report Types.?
There are several categories of Pentaho reports :
Transactional Reports : Data to be used form transactions. Objective is to publish detailed and comprehensive data for day-to-day organization’s activities like purchase orders, sales reporting.
Tactical Reports : data comes from daily or weekly transactional data summary. Objective is to present short-term information for instant decision making like replacing merchandize.
Strategic Reports : data comes from stable and reliable sources to create long-term business information reports like season sales analysis.
Helper Reports : data comes from various resources and includes images, videos to present a variety of activities.
What Are Variables And Arguments In Transformations?
Transformations dialog box consists of two different tables: one of arguments and the other of variables. While arguments refer to command line specified during batch processing, PDI variables refer to objects that are set in a previous transformation/job in the OS.
How To Configure Jndi For Pentaho Di Server?
Pentaho offers JNDI connection configuration for local DI to avoid continuous running of application server during the development and testing of transformations. Edit the properties in jdbc.propertiesfile located at…data-integration-serverpentaho-solutionssystemsimple-jndi.
Explain Pentaho Reporting Evaluation.?
Pentaho Reporting evaluation is a complete package of its reporting abilities, activities and tools, specifically designed for first-phase evaluation like accessing the sample, generating and updating reports, viewing them and performing various interactions. This evaluation consists of Pentaho platform components, Report Designer and ad hoc interface for reporting used for local installation.
Can Field Names In A Row Duplicates In Pentaho?
No, Pentaho doesn’t allow field duplication.
Does Transformation Allow Filed Duplication?
“Select Values” will rename a field as you select the original field also. The original field will have a duplicate name of the other field now.
What Is Ods?
ODS is Operational Data Store which comes in between of data warehouse and staging area.
Differentiate Between Etl Tool And Olap Tool?
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.
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.