What is ETL and why do we need it?
What is the ETL process in data warehouse?
- ETL Process in Data Warehouses 1 Extraction In this step of ETL architecture, data is extracted from the source system into the staging area. ... 2 Transformation Data extracted from source server is raw and not usable in its original form. Therefore it needs to be cleansed, mapped and transformed. ... 3 Loading
What is a direct move in ETL?
- It is one of the important ETL concepts where you apply a set of functions on extracted data. Data that does not require any transformation is called as direct move or pass through data. In transformation step, you can perform customized operations on data. For instance, if the user wants sum-of-sales revenue which is not in the database.
What are the best practices for ETL process steps?
- Following are the best practices for ETL Process steps: Every organization would like to have all the data clean, but most of them are not ready to pay to wait or not ready to wait. To clean it all would simply take too long, so it is better not to try to cleanse all the data.
Share this Post: