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