SQL or PL/SQL for Hand coding ETL

View previous topic View next topic Go down

SQL or PL/SQL for Hand coding ETL

Post  tropically on Mon May 18, 2009 12:20 pm

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.

tropically

Posts : 13
Join date : 2009-05-12

View user profile

Back to top Go down

Re: SQL or PL/SQL for Hand coding ETL

Post  ngalemmo on Tue May 19, 2009 7:23 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum