ETL - Extraction ,Transformation and Loading

Posted on June 16th, 2008 by Kamlesh Jethwa

ETL ( Extraction ,Transformation and Loading )

This phase of ETL ( Extraction ,Transformation and Loading ) takes the most of any Datawarehousing project.

This phase has to get the source data and following:
· Understand the Business Rules
· Understand the necessary Columns of tables.
· Understand the Logical data model
· Understand the Physical data model

The Developer has to produce following deliverables:
· ETL Script / ETL Package in the ETL tool
· Data Mapping Document

Next >> OLAP Cube Design


Add your opinion - this will move the pointer
get dashboard plugin?

Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers)

Free Dashboards

Here are some more interesting Articles
  • Data Modeling -Logical data model -Physical data model
  • Life cycle of a DW ( Data Warehouse ) project
  • Life cycle of a DW ( Data Warehouse ) project
  • Performance Tuning -ETL - Query Processing -Report Delivery
  • Benefits of data warehousing
  • Data Conversion for Oracle Applications

    • One Response to “ETL - Extraction ,Transformation and Loading”

    1. Business Intelligence (BI) - ERP - Dashboards » Data Modeling -Logical data model -Physical data model, on June 16th, 2008 at 3:53 pm Said:

      […] Next >> ETL […]

    Leave a Reply

    You must be logged in to post a comment.

    « Physical Environment Setup -Development servers- Testing Servers - Production server OLAP Cube Design »

    • About InfoPurple

      InfoPurple is an Oracle Digest that collects best articles from the best minds from entire blogosphere. We collect them and post an excerpt and point back to the main site. This allows for a consolidated view of Oracle Apps related topics. If you would like to add your website to be included then please email us (infopurple8888 AT gmail DOT com) your web url. If you would like to get your website removed then send us an email and we will remove it. -- infoK purple