Oracle Warehouse
Builder
The good news for OWB users is that recent
releases of OWB (9.0.4 upwards) support
table functions as transformations in a mapping process.
The current version of OWB (10g Release 1)
supports table functions that you've written and then
import into the OWB repository, whilst the next release,
codenamed 'Paris', will allow you to
build the table function graphically within OWB. This
support for table functions, together with the ability to
fine tune the load parameters and take advantage of 9i ETL
functions like MERGE and pipelining actually invalidate
Bert's argument that ETL tools don't produce efficient,
optimal code, although to be honest all of this is fairly
new functionality and the book is a couple of years old
now.
