Hand coding ETL questions
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 : 1842
- Numbers of messages : 8656
- Numbers of users : 3787
- Numbers of points : 1497
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
I'm a developer with 10 years of exclusive C++, and about a year and a half of splitting my time with C#. I'm solid on the core concepts of C#, and could probably pick up the GUI components pretty quickly. I've done a bit of gaming work before, though
Q 4. Explain Skinner’s theory of instrumental conditioning and its implications for marketing strategy?
Q. 5. What is VALS? Describe the different VALS groups with high resources and low resources?
Q 6. What is the purpose of motivational research?
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
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Search
See also
Informations
2 Replies For the topic :
"Hand coding ETL questions"
This topic has been viewed 1781 times.
Last message :
14/05/2009 at 02h40 by "mugen_kanosei"
