Data warehouse

 hi everyone...

 DATA WAREHOUSE..???what in ur mind right now..???

i will explain at u all about data warehouse k. Data warehouse extend the transformation of data into information. In the 1990's executives become less concerned with business operations and more concerned with overall business function.

Data Warehouse means a logical collection of information - gathered from many different operational database - that supports business analysis activities and decision - making tasks.

Extraction, transformation and loading ( ETL ) : a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.

Data mart : contains a subset of data warehouse information.

Example of DATA WAREHOUSE MODEL :

                                                 

CUBE means common term for the representation of multidimensional information.

                                                

          Information Cleansing or Scrubbing.

A process that weeds out and fixes or discards inconsistent,   incorrect or incomplete information.