- Spoon : Spoon is a desktop graphical interface to create, edit, run or debug transformations and jobs.
- Pan : Command line interface to run transformations and jobs. Data can be manipulated using pan interface.
- Kitchen : Command line interface to run jobs.
- Carte : Web container to set up ETL server for remote execution.
DW & BI Interview Questions
Data warehouse interview questions, Informatica interview questions, Pentaho interview questions.
Saturday, September 12, 2015
Pentaho Data Integration ( PDI ) Interview Questions
1) What are the different components of Pentaho Data Integration tool ?
Monday, September 7, 2015
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?
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?
Saturday, September 5, 2015
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 ?
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 ?
Subscribe to:
Posts (Atom)