Question. How do you load 80 million records into the Data warehouse?Answer. Slowly! As we are now in version 7.8 of the CRM application there is lots of work around upgrading from previous versions. Normally an upgrade of the data warehouse will provide companies with an opportunity to reassess what…
Author: Adrian Ward
30 Years working on Oracle systems, specialising in Oracle analytics. Previously known as OBIEE, and before that Seibel Analytics
Oracle ACE
A quick note on Narratives
Narratives are very useful to give user information in a readable format. Some data is not easy to name so a more descriptive comment can be used instead of jus the column nameConsider:Run Date24/08/06 What does this mean? You could use: ‘The date when the latest ETL was run is:…
A slow day at the Coal Face
August 31st Today is a slow day. The database is down due to constant ORA-03113 errors, and sometimes 12152 errors. I don’t know what they are but it means we get to work late nights and weekends til the end of the project. If any of you know what these…