Book Review - OWB 11g - Getting Started (Bob Griesemer)
One of the privileges of being in the BIDW field for long enough, is to do book reviews. Currently, I am looking at the book by Packt Publishing, titled " Oracle Warehouse Builder 11g Getting Started ." The author is Bob Griesemer. This book has 9 interesting chapters, however I am jumping to Ch5 for now as it is the Extract, Transform and Load Basics. Someone with a weaker ETL background could reach this first. The interesting section of this chapter is "To Stage or not to Stage." The author talks about key considerations in ETL, such as: > For faster movement of data, amount of source data, degree of manipulation of source data and nature of source is important; AND > Handling failures due to connectivity and handling changes in the source data. The author has presented options for extracting data directly into staging without worrying about computations in the source system or extract along with some manipulation from the source. He brings up a good poin