Data warehouse is three tiers architecture. Data Warehouse also called as Enterprise data warehouse (EDW). It is a system used for data analysis and reporting and business intelligence. Data warehouses are Central Repositories of integrated data from one or more disparate sources. They also store historic and current data in one single place. The data warehousing concept was intended to provide an architectural model for the flow of data from operational systems to decision support environments.
ETL and ELT are the two main Approached used to build a data warehouse system. Extract, Transform, Load (ETL) data warehouse uses for data integration, staging and access layers for its key functions. Extract Load, Transform (ELT) data warehouse is a separate ETL tool for data transformation. Instead, it maintains a staging area inside the data warehouse itself.Types of Data warehouses:
TIBCO is Active Matrix Business Works and TIBCO Business Works is a processing engine with connectivity components graphical user interface (GUI) for defining business processes
TIBCO makes integration server software for enterprises TIBCO Software Inc. Provides integration, analytics and event-processing software for companies to use on-premises or cloud computing environments.
Is one of the popular Relational Database Management Systems. TERADATA is a fully scalable relational database management system TERADATA is database which is planned to manage logical queries.
Data Stage is an integration tool, used in this space to perform the ETL for a data warehouse. It is essentially the data API into the warehouse.