Wednesday, June 24th, 2009 by Venkatakrishnan J
In a prior blog entry here, i had shown the advantages of using the MODEL clause. I also showed how the MODEL clause can be used to visualize the relational data in a multi-dimensional format. In most cases, using the MODEL clause alone can be sufficient. Just to recap, the MODEL clause divides your resultant […]
Sunday, June 21st, 2009 by Peter Scott
One of the things I sometimes come across when looking at legacy ETL code for data loading is the misuse of query hints to “improve” data load performance. Sometimes DBAs or developers do not remember that “tuning the select” may not be the same thing as “tuning the insert”; Jonathan Lewis wrote about an example […]
Thursday, June 11th, 2009 by Stewart Bryson
If you follow the blog, then you know that Mark recently posted about materialized views for aggregation, located here.
One of the issues he encountered was how to refresh materialized views based on tables loaded with partition exchanges… a common approach to loading fact tables while minimizing the downtime for the reporting schema. Once the […]
Monday, June 1st, 2009 by Jennifer Albu
After my last blog “Introducing the RittmanMead Delphi Methodology”, one of you posted the comment below. My answer ended up being so long that I decided to turn my response into my next blog. Here is the comment:
“What about iterations within the Delphi 18 stages? Do you have a structure for incorporating feedback from later […]
Tuesday, May 26th, 2009 by Peter Scott
One of my pet hates is the inappropriate use of dynamic SQL within ETL processes, for example building a command as VARCHAR2 string then using it in an “execute immediate” statement. Putting commands into strings whether hard-coded ones within the package or procedure, retrieved from some ‘code’ table in the database or even built on-the-fly […]
