How easy is it to create ETL processes with OWB?
The ETL process is handled by defining and deploying mappings. OWB gives the user a highly graphical and easy-to-use interface, allowing users to model the ETL process by dragging and dropping objects on a mapping canvas. After connecting the objects, OWB will generate a pl/sql package from this logical drawing, which will provide the actual data movement.