mugen_kanosei at 02h40
14
May
2009
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 load is in one perl script that is set to run every night. I'm wanting to code something more like what the books suggest, metadata driven, batch scheduling, etc. But im unsure how this is getting handled in gen
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 load is in one perl script that is set to run every night. I'm wanting to code something more like what the books suggest, metadata driven, batch scheduling, etc. But im unsure how this is getting handled in gen
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
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 error
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
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
the questions:
whats your name (first):
Birthday:
fav color/food:
Kids/pets:
3 things you can live with out:
give one thing that makes you mad that people do:
How has Tipstirs sight helped you?
Forums from same category
LEGO Island Discussion, modding, news and more!
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
HmongThoobNtiajTeb. com/
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
Informations
2 Replies For the topic :
"Hand coding ETL questions"
This topic has been viewed 1787 times.
Last message :
14/05/2009 at 02h40 by "mugen_kanosei"






