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 data modelling?
Data modeling is the process of a. identifying data b. defining data c. structuring (schema) & associating (ER & constraints) data to meet its business requirement.
Data modeling is the process of
See lessa. identifying data
b. defining data
c. structuring (schema) & associating (ER & constraints) data
to meet its business requirement.
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 lessWhat is data modelling?
Data modelling is a scientific way of documenting complex data systems by way of a diagram to give a pictorial and conceptual representation of the system. You could also expand on any experience that you have had with data modelling.
Data modelling is a scientific way of documenting complex data systems by way of a diagram to give a pictorial and conceptual representation of the system. You could also expand on any experience that you have had with data modelling.
See lessWhat are the differences between structured and unstructured data?
Data engineers constantly work with data that is coming into the systems in all sorts of formats. Broadly categorizing them as structured and unstructured. They differ in the way these are stored and accessed. For your convenience, some of the differences are listed. Criteria Structured data UnstrucRead more
Data engineers constantly work with data that is coming into the systems in all sorts of formats. Broadly categorizing them as structured and unstructured. They differ in the way these are stored and accessed. For your convenience, some of the differences are listed.
What are the core skills required in a data engineer?
Skills that are essential for a data engineer are Good understanding of database design & architecture. Well versed in both SQL and NoSQL databases systems. A good level of experience in data stores and distributed systems like Hadoop. Expertise in data warehousing and ETL tools.
Skills that are essential for a data engineer are