Steps involving in implementation of ETL process

1. Creating a Source definition.
2. Creating a Target definition.
3. Design a mapping with or without transformation rule.
4. Create a session for each mapping.
5. Create a wokflow.
6. Finally start the workflow.

Note: In real-time environment, all the source tables and target tables are created by DBA. We just import the definition of the tables.