Data Warehouse so simple...

Whats up guys..?? I know you eagerly to find out the dataware house and datawarehousing..
Mainly dataware house means that a DATABASE.It maintained seperately from organisation to operational databases.

Now Data Warehousing also very important term..It is the process of constructing and using data warehouses.It mainly tools and architecture that used by company executives for organize,understand and use data for taking straegic decisions..

Main features of DATA WAREHOUSE are:

1. Subject Oriented: Databases organized based on major subjects like customer,supplier,product etc..
2. Integrated: Databases constructed by integrating multiple differrent sources.
3. Time-Variant: Data are stored for provide information in historical perpective.
4. Non-Volatile: Physically seperate store of data for transfer from application data.

The construction of data warehouse require mainly 3 process..

1. DATA CLEANING
2. DATA INTEGRATION
3. DATA CONSOLIDATION..

THese are the important points for the DATA WAREHOUSE...

If you like this conent.. then please FOLLOW ME for more updates.

THANK YOU

HAVE A NICE DAY