Database Software

The OWB Users Guide is good for defining the OWB operators, but I'm having some difficulty deciding how to best combine those operators to formulate a mapping. I'm hoping someone will be able to point me to documentation that will fill the gap. It wouldn't necessarily need to be OWB specific.

Some example questions that I'm hoping an "ETL patterns" book or document would address:

1. High level implementation decisions (Is the source data staged locally? How/when are the changed records identified?)
2. Options for locally staging data.
3. Options for implementing a Type I/II/III SCD.
4. Options for implementing a cube.

I was able to find "Slowly Changing Dimensions with Oracle9i Warehouse Builder" (http://otn.oracle.com/sample_code/products/warehouse/files/SCDWhitePaper.zip) that gave a lot of guidance on the SCD issues. The Type II SCD mapping presented in that document uses 10 operators. I never would have been able to formulate that on my own based on just reading the OWB documentation.

Thanks,
Brian