Pentaho Data Integration ( PDI ) Interview Questions

1) What are the different components of Pentaho Data Integration tool ?

1. Spoon : Spoon is a desktop graphical interface to create, edit, run or debug transformations and jobs. 
2. Pan : Command line interface to run transformations and jobs. Data can be manipulated using pan interface.
3. Kitchen : Command line interface to run jobs.
4. Carte : Web container to set up ETL server for remote execution.

Informatica Interview Questions for Developer role

1) What are the different components of Informatica mapping ?

Informatica mapping defines the data flow from source to target. Source definition, target definition, transformations and links are the components of a mapping.


2) What is a mapplet?

Data Warehouse Concepts Interview Questions

1) Describe Enterprise Data Warehouse ?

Enterprise Data warehouse ( EDW or EDH ) store current and historical data integrated from one or more disparate sources. This is a system used for data analysis and reporting purposes.

Bill Inmon created the accepted definition of what a data warehouse is - a subject oriented, nonvolatile, integrated, time variant collection of data in support of management's decisions..


2) What is a Data mart ?