Featured Post

Applying Email Validation to a JavaFX TextField Using Binding

This example uses the same controller as in a previous post but adds a use case to support email validation.  A Commons Validator object is ...

Saturday, January 29, 2011

[TUTORIAL] Loading a Dimension with CloverETL

Using CloverETL, load an Excel spreadsheet of public school revenue data into a MySQL dimension table called SR_DIM_FUND. As the spreadsheet is loaded, consult a lookup CSV file to make the input data conform with a standard.

A more robust dimensional model will account for change by storing effective date columns. This particular example is for an initial dimension load or to correct a record, called a Type 1 (Kimball) or upsert.

No comments:

Post a Comment