| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: In what scenario ETL coding is preferred than Database level SQL,PL/SQL coding?
|
| April 04, 2009 13:37:06 |
#4 |
| pvsunil123 |
Member Since: April 2009 Total Comments: 1 |
RE: In what scenario ETL coding is preferred than Database level SQL,PL/SQL coding?
|
I assume ETL coding means using ETL tools like Informatica.
If the data is coming from completely different source systems as flat files, cobol files, RDBMS, XML, etc., it is better to use some intelligent ETL tools like informatica but if the data is from one or two simple sources like flat files and single RDBMS like Oracle, there is no need to have expensive ETL tools, this can be managed with SQL,PL/SQL coding or database data loading tools like SQL Loader or SQL Server DTS. |
| |
Back To Question | |
