Data Warehousing

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:
  • Top Down method
  • Bottom Up method
  • Hybrid method
Key Benefits of Data warehouse:
  • Used to help an organization make decisions better and faster
  • improving performance of both systems
  • Consolidates data from many of the sources
  • Quality of Data, consistency and accuracy
  • Historical Intelligence
  • Separates analytics processing from transactional databases




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.



INFORMATICA is clearly a market leader in the fields of data integration and data quality services. The INFORMATICA Power Center is a powerful tool to integrate