Basics: Extract Transform Load

• Data Processing

• • Pull data from X,Y,Z and insert or update in the Warehouse

• Logical Transformations

• • Sum, Join, Outer Join, Bucketize, calculate time variant items
  • Everything you need to process flat files, XML, Tables into a set of tables that represent your reporting data.

• Tools

• • Visual and include a Logical and Physical representation
  • Kettle and OWB

• SQL Scripts / Perl / Cron