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 ]
Post your comment

    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.