Session B: Information Systems and Data Warehouse
Jean-François DESNOS: A National Data Warehouse Project for French Universities

6. Data Stage job example: loading the budget in the BUDGET target table.

Job parameters are (1) university structure code and (2) a set of calendar years.

Loading DWH BUDGET table

Why use a commercial ETL tool ?

ETL (extraction transformation loading) can be developed using SQL and C for example, and not a specific tool, which is expensive (15,000 to 50,000 Euro).

But such an ETL software allows:



© This publication and its compilation in form and content is copyrighted. Every realization which is not explicitly allowed by copyright law requires a written agreement. Especially, this holds for reprography and processing / storing by electronic systems.

EUNIS Proceeding DTD Version 1.0
HTML - Version create: Fri Mar 23 15:28:59 2001