Home of Data.

•Extraction, transformation, and loading (ETL)  is 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.

information also have cleaning and scrubbing, which is the process of eliminating and dispose all the unwanted information.it also involves the process of correcting the mistakes in the information.

same goes to our house, we also do the regularly cleaning to make sure our house is clean and tidy, so same case happen in data warehouse.