Tuesday, June 18, 2013

[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: