SQL rules
Extraction, Transformation, and Loading
- INSERT INTO customers_tableSELECT InitCap(name), CleanPhone(phone)FROM customers_sourceview
- Large library of built-in functions, or write more in Java
- Use UPDATE, DELETE, or Java for more sophisticated loads
Many Benefits
- No new paradigms or languages
- Easy to preview results
- Leverage high performance query engine and data store
- Leverage query optimization techniques