A typical data warehouse consists of …………………
kvnmurty:
transactional data / historical data / operational data /
Answers
Answered by
6
A typical data ware house consists of several components to meed demands for its various stages
The various Stages of a data warehouse are
1.Data Capture
2.Transformation & Cleansing
3.Aggregation & Analysis
4. And Presentation
At Data capture stage we Have various operational systems from which data is fed into Transactional Databases
At Transformation & cleansing stage data is transformed and cleansed using various ETL tools (Extract , Transform and Load)
At Aggregation and Analysis there are various query tools that fetches data from data marts
Also attaching some images that would highlight more about the data warehouse
The various Stages of a data warehouse are
1.Data Capture
2.Transformation & Cleansing
3.Aggregation & Analysis
4. And Presentation
At Data capture stage we Have various operational systems from which data is fed into Transactional Databases
At Transformation & cleansing stage data is transformed and cleansed using various ETL tools (Extract , Transform and Load)
At Aggregation and Analysis there are various query tools that fetches data from data marts
Also attaching some images that would highlight more about the data warehouse
Attachments:
Answered by
1
I think it might be an F/B. So, I am not going to elaborate on this but fill in the missing information (fill in the blanks).
Solution:
A typical data warehouse consists of data marts and operational data.
Hope that helps you!
If it did, please be sure to click on THANKS button and rate my answer.
And if my answer helps the most, do mark my answer as the BRAINILIEST.
Solution:
A typical data warehouse consists of data marts and operational data.
Hope that helps you!
If it did, please be sure to click on THANKS button and rate my answer.
And if my answer helps the most, do mark my answer as the BRAINILIEST.
Similar questions