Join the Codozzle community now and ask questions, share knowledge, and connect with peers and industry leaders!
Log in to keep sharpening those coding skills.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Data Warehouse & Data Mart difference?
Data Warehouse: A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or ad hoc queries, and decision making. Data Mart: A Data Mart is a condensed version of Data Warehouse and is designed for use by a specific depaRead more
Data Warehouse:
A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or ad hoc queries, and decision making.
Data Mart:
See lessA Data Mart is a condensed version of Data Warehouse and is designed for use by a specific department, unit or set of users in an organization
What is the difference between ETL and Pentaho ?
ETL - refers to Extract Transform & Load. It is a three stage process. Stage-1 (Extract): The staging layer stores raw data extracted from each of the disparate sources. Stage-2(Transform): The integration layer integrates the disparate data sets by transforming the data from the staging layer SRead more
ETL – refers to Extract Transform & Load. It is a three stage process.
Stage-1 (Extract): The staging layer stores raw data extracted from each of the disparate sources.
Stage-2(Transform): The integration layer integrates the disparate data sets by transforming the data from the staging layer
Stage-3 (Load): Storing the transformed data in a database (often referred as Data Warehouse)
Pentaho is a ETL tool developed by Hitachi Vantara.
In short, ETL is a process and Pentaho is a tool used in ETL process.
See less