Question

explain the process of designing the ETL.(extract transform load)

Also explain the Designing of Staging areas and creating of mapping.

Also discuss in details Transformations in particular: STORE mapping, PRODUCT Mapping, and SALES cube mapping. and discuss the Features and Benefits of OWB.

Answer 1

Answer : Given data

ETL Process :

* ETL is the process by which data is extracted from data sources (that are not optimized for analytics), and moved to a central host (which is).

* The exact steps in that process might differ from one ETL tool to the next, but the end result is the same.

* At its most basic, the ETL process encompasses data extraction, transformation, and loading.

* While the abbreviation implies a neat, three-step process – extract, transform, load – this simple definition doesn’t capture:

* The transportation of data

* The overlap between each of these stages

* How new technologies are changing this flow

_______________THE END___________________