ODC Appreciation Day: Using PIVOT for Unknown Dimensions

This post goes to #ThanksODC (formerly known as #ThanksOTN) which is initiated by Tim Hall (aka OracleBase).
But first, story time of this. I prepared this bunch of code (continue reading below please), because of being stubborn of being performance enthusiast. While I was working as a consultant, I was first invited to increase performance of an ETL which is already running on production and was running at least 12 hours per run (monthly). We did our best with the features of the ETL tool, paralleled queries, and managed to reduce it to 8-9 hours. But, “it-was-not-enough”!
Continue reading

OTN EMEA Tour is around the corner

I will be travelling to start OTN EMEA Tour early in tomorrow morning (16th May – Tuesday). Initial thanks goes to Oracle ACE Program and Oracle Technology Network for supporting me to be a part of this event and share my expertise & experience with Oracle users groups that are

My appearances will be as follows;

  • Baku, AzOUG
    • 20th May: EDQ, OGG and ODI over Exadata in the Cloud for Perfection
    • 20th May: Is Data Warehousing dying?
  • Ljubljana, SIOUG (Agenda)
    • 23rd May – 09:50 am: Is Data Warehousing dying?
    • 23rd May – 1:30 pm: How to solve complex business requirements with Oracle Data Integrator?
  • Düsseldorf, DOAG (Speakers, Agenda)
    • 30th May – 10:15 am: Best Practices with ODI : Flexibility
    • 30th May – 11:15 am: Is Data Warehousing dying?

Again, early flights, being away from home and many potential issues are waiting for me. But, serving back to community… Priceless.!

Hope to meet you in one of the events and stay tunes for my tweets, instagram photos and blog.

#AMIS25 – the Conference

AMIS (Aero Management Information Management System) is celebrating its 25 glorious years and that was why venue is intentionally picked as an airport hangar near Katwijk. I’d like to thank to initially to Oracle ACE Program for letting this happen, then biggest thanks to Lucas Jelemma and also everybody involved in conference (speacial credits to Saskia van der Maat and Lianne Verhoeven for taking care of all the speakers)

AMIS25-Conf-01
Venue from a top view

Continue reading