Components of Data Warehouse?
Below are the components of a data warehouse:-
Source databases/systems (Example - Legacy, relational, text or external sources)
Source databases/systems (Example - Legacy, relational, text or external sources)
Data extraction/transformation/load
(ETL) tool (Example –Informatica, Datastage)
Data warehouse maintenance and
administration tools
Data modeling tool or interface to external
data models (Example –Erwin)
Warehouse databases (Example-Teradata,
Oracle, and MySql)
End-user data access and analysis/reporting tools (Example
–OBIEE, Business Objects)
No comments:
Post a Comment