snippetsqlMinor
Methodology & Architecture to Create ETL Process
Viewed 0 times
architectureprocesscreatemethodologyetl
Problem
What book or webpage can I read the architecture and methodology for creating ETL process?
In other words, I'm looking for "how to do it" to create a ETL process when you have many source system to be involved and you also have a data warehouse.
In other words, I'm looking for "how to do it" to create a ETL process when you have many source system to be involved and you also have a data warehouse.
Solution
I would recommend reading The Data Warehouse Toolkit by Ralph Kimball. Goes through the theory, with some good examples, and will leave you with a solid understanding of the theory. Then you can look at the tools themselves.
If you're looking for something to build your ETL process, Pentaho have something called the "Star Modeller" which lets you model your dwh, and it then builds the ETL/cubes etc. But it's pretty new and far from complete - worth keeping an eye on though.
If you're looking for something to build your ETL process, Pentaho have something called the "Star Modeller" which lets you model your dwh, and it then builds the ETL/cubes etc. But it's pretty new and far from complete - worth keeping an eye on though.
Context
StackExchange Database Administrators Q#19239, answer score: 4
Revisions (0)
No revisions yet.