SQL or PL/SQL for Hand coding ETL
2 posters
Page 1 of 1
SQL or PL/SQL for Hand coding ETL
Hi
Wanted to get a general idea, as to what others have used when hand coding ETL for loading data into data marts.
My thoughts : Straight inserts , updates, merges are faster, however can't capture errors. Pl/SQL is more flexible allowing to log errors if any.
Any thoughts would be appreciated.
Wanted to get a general idea, as to what others have used when hand coding ETL for loading data into data marts.
My thoughts : Straight inserts , updates, merges are faster, however can't capture errors. Pl/SQL is more flexible allowing to log errors if any.
Any thoughts would be appreciated.
tropically- Posts : 13
Join date : 2009-05-12
Re: SQL or PL/SQL for Hand coding ETL
There needs to be a process to tie everything together, which would seem to dictate PL/SQL rather than a bunch of SQL scripts run through some OS script. Plus you may run into a situation where set operations are not the best way to go.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|