A good idea when working with Data Vault is to generate the tables and load processes to avoid a lot of manual development. biGENiUS, the Data Warehouse automation tool of Trivadis, is now able to generate Data Vault objects.
Dynamic SQL is a wonderful feature with a lot of flexibility. Unfortunately, it is not trivial to see the executed SQL statements. A simple trick helps to test and debug PL/SQL code with Dynamic SQL.
Oracle Warehouse Builder (OWB) is at the end of its lifecycle. The ETL tool will not be supported by Oracle in the future. But many customers have built data warehouses with OWB. What can they do with their existing OWB projects? A Trivadis white paper describes different migration scenarios.