I look at this like I look at the use of assembly language versus C/Java/COBOL. You can write everything in assembly language, but it will be harder to maintain. PL/SQL (I assumed that you meant ETL to PL/SQL. SQL*Loader is equivalent to the “L” in ETL) can be used to do the “ET” part of ETL. But maintenance of PL/SQL is not quite as easy as maintain as ETL tools like Informatica or DataStage.
The one place where the ETL tools have a huge advantage is in metadata. Since I believe metadata is extremely important, I would lean toward using an ETL tool versus PL/SQL.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access