What is ETL process? How many steps ETL contains?
What is ETL process? How many steps ETL contains? Explain with example.
- ETL stands for Extraction, Transforming and Loading.
- Data is extracted from the source(database servers), and applied for generating business role on it.
The following are the steps involved :
- Define the source [ define the odbc connection to the database source ]
- Define the target [ create the odbc connection to the target database ]
- Create the mapping [ Apply business role here by adding transformations and define the data flow from source to target ]
- Create the session [ Mapping instructions ]
- Create the work flow [ Instructions that run on the sessions ]
Discussion
- RE: What is ETL process? How many steps ETL contains? -Steve (07/17/14)
- As stated before ETL stands for Extract, Transform, Load. Generally there are 3 steps, Extract, Transform, and Load.
Of course, each of these steps could have many sub-steps. Especially the Transform step.