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

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 error

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

Kingdom Hearts Re:coded
So yeah my friend just got this game for me yesterday :] and well uh, I've never played any KH games or FF games before so I'm playing it and kinda lost but hahaha I think i can catch on So what do you guys think of the game? :]

Where should the ETL be ?
As I understand in organisational IT architecture there are 3 tiers. 1st tier(Data storage layer) : All the databases . 2nd tier(Business Tier ): All the middleware applications that include ETLs, messaging middleware , object oriented middleware

ETL from 250+ disparate customer host systems
My task is to produce an ETL process that pulls data daily from our customer systems (which can be most any database/OS). The data will be loaded into our central system, an analysis will be run and the aggregate data solution sent back to all customers.

ETL Replacement Suggestions Needed
Greetings, I’ve just begun the process of researching a fitting ETL tool that will allow for a simplistic user friendly source extraction to staging configuration for minimal licensing costs. We are in the works of decommissioning a very old version of

ETL Auditing standards and how to implement them.
Can any one share his/her experiences of what are the Industry standard ETL Auditing Standards you use and how you implelemt them. Any Tool specific examples will be appreciated: e.g Datastage and Informatica Thanks MJ

ETL for Accumulating Snapshot
I'm looking for a book, sql code, web links, anything to get me started on creating the ETL for an Accumulating Snapshot fact table. I've not yet been able to attend the Kimball ETL class (but the Dimensional Modeling class was great!). Does anyone

ETL as a source for some attributes of a dimension
Hi all, is it allowed to programmatically add value on a row of a dimension by the etl process ? For instance : Source contains only books : NK | NAME 142 | invisible Etl source the DW dimension 'Product' and programmatically add a category :

Open source ETL vs commercial ETL
Anybody have experience with open source etl like Talend or Pentaho? They are becoming more popular, and I was wondering what advantages/ disadvantages of open source vs commercial etl tools. Any downsides of using open source for SOX or HIPAA?

ETL Architecture
Hi My company is currently planning on building a datawarehouse. We are an oracle shop and are considering the approach for data migration from client servers to the datamart. Thoughts we have 1) Asynchronous CDC . I believe oracle now is replacing

ETL approach for replacing multiple dates in one row.
We have a Fact table that stores several key dates in the life cycle of a customer. Each of these dates is supposed to be a surrogate key pointing to the date dimension. My questions pertains to efficiently replacing these dates with surrogate keys in the

How to consolidate numerous ETL processes?
Hi, Within the department there are numerous users whose ETL processes are slightly identical to one another (e.g. an extra variable). This not only puts a burden on the server load, but also create problems where a certain measure is not identical