Database implementation for an ETL project

sureshchandra · Post by **sureshchandra** » Fri Jan 16, 2009 2:00 am

Hi all,
we are starting a new ETL project.Source is DB2 and Target is Oracle.Please tell what are the necessary steps to implement the Data warehousing project .What are the inputs a devloper required to implement an ETL Project ,there is any specific Resource(guy) required or a developer can do that.Please hepl me

Thanks&Regards
Chandra

ray.wurlod · Post by **ray.wurlod** » Fri Jan 16, 2009 5:17 am

An ETL project can not exist "in thin air" - it must exist towards some goal.

In all cases there needs to be a business case established and, following from that, an analysis of what is required. This is typically the realm of someone with a title like "business analyst", often with help from interested stakeholders and subject matter experts.

One deliverable from this analysis should be a specification for the ETL, often in the form of a source-to-target mapping document.

Early on you may need to have, develop or hire some expertise in testing, as there will be various times during and after the development of ETL tasks that they need to be tested thoroughly before going into production.

sureshchandra · Post by **sureshchandra** » Sun Jan 18, 2009 7:51 am

Hi Ray,
A specific Resource is required or a consultant can do the analysis.

Thanks&Regards
Chandra