Sunday, 23 September 2012

DATA WAREHOUSE !

Assalamualaikum and hoyeehhh! :)

It is all about data warehouse. It is logically to collect the info. It is how we get the data and info and how the data can know that we have settle our work..How they work actually?? So for this chapter it shows and make we understand about it.

The data warehouse complies info of internal databases and external databases though extraction, transformation and loading (ETL).

Extraction :: how and where we get the info?? Whether internal or external sources??
Transformation :: when we have the data we should can understand what the data is all about.
Loading :: it is about when we upload the info or data that we have.

To maintain the quality info in data house or data mart is extremely important. It has information cleansing or scrubbing system which is a process that weeds out and fixes or discard inconsistent, incorrect or incomplete info.


* the shortest entry and I dont know why i write too short..hahaha

takecare and tq everyone!!! :)




No comments: