DATA WAREHOUSING

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

data-warehouse

tibcobw

TIBCO BW

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

TIBCO

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.

teradata

TERA DATA

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.

datastage

DATA STAGE

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

INFORMATICA

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