Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is ETL and why is it necessary. Is it possible to run analytics on at OLTP database? Explain? Why does the data have to
- What is ETL and why is it necessary.
- Is it possible to run analytics on at OLTP database? Explain?
- Why does the data have to be transformed? What is being transformed?
- Explain the difference between full extraction and incremental extraction. Provide an example for each extraction technique.
- What is a flat file and where are flat files used in the ETL process?
- Explain the reasons for or against the use of separate transactional and informational systems.
- Discuss why data warehouses and other OLAP structures are used for staging and analyzing data.
- Explain the layered scalable architecture of data warehouse modeling.
- Explain multidimensional data warehouse models, including star schemas and snowflake schemas.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started