Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

SQL or PL/SQL for Hand coding ETL

Go down

SQL or PL/SQL for Hand coding ETL Empty SQL or PL/SQL for Hand coding ETL

Post  tropically 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

Back to top Go down

SQL or PL/SQL for Hand coding ETL Empty Re: SQL or PL/SQL for Hand coding ETL

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

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

http://aginity.com

Back to top Go down

Back to top


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