SQL or PL/SQL for Hand coding ETL

tropically at 18h20
18
May
2009
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.

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Hand-Coded ETL revisited
Hi I read Gary Nissen's article, 'Is Hand-Coded ETL the Way to Go?', with interest. Given that this was written nearly six years ago, I wonder whether the position has changed i.e. whather ETL tools are now more strongly recommended ober
Hand coding ETL questions
I know the numerous pros of using an ETL tool, but due to circumstances outside my control I have to hand code the ETL. My questions are in regards to actual coding practices. I am currently loading a couple of dimensions using perl. So far the entire loa
Three Coding Problems..Help please!!
First off, I am VERY MUCH a noob at this! I will need very clear, cave-man like instructions please. Problem #1- I would like to post a youtube video on the portal (which is set as the homepage). I know how to embed a video, but I do not know what
michael-jackson-left-hand-right-hand
Changing Forum Coding.
This idea will make most of your ideas come true! Just allow the lead admin of any forum to change the coding of their forum. This way whatever the admin wants to do he can do!
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"SQL or PL/SQL for Hand coding ETL"

This topic has been viewed 1936 times.

Last message :
18/05/2009 at 18h20 by "tropically"