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

Advertisements

#OTNEMEATour First Leg #Harmony17

After reaching to Helsinki, sleeping on 3 complete empty seats lied down by luck (I left my emergency seat for this reason), I made a small city tour and reached the meeting place (in front of Presidential residence – intentionally mentioned this because it is the real residential palace of Finland President with non-moving soldiers in front of the building) and met with Frits Hoogland and Patrick Barel. Speakers dinner is very well organised on a ancient trade wooden boat and sailing with the power of the wind (rarely with engine when we are behind the schedule) and we were all sailor-man (in real). In spite of sun, it was about 4-5C and some of us was downstairs in order not to get cold because of freezing wind. Please click pictures to enlarge. Continue reading

#ThanksOTN @OracleOTN Appreciation Day

Initial thanks to Oracle Technology Network and Oracle ACE Program for making us connect with Oracle community. And to Tim Hall (A.K.A. oracle-base) for setting all of us up for sharing some content with Oracle Community. So let’s start sharing my content. Click #ThanksOTN for all the tweets across OTN Appreciation Day.

Continue reading

Oracle DRM for RDM from MDM

As I started reading a field report about Oracle DRM solution from MDM Institute (shared by Jeff Pollock in LinkedIn), I started to sketch out during this read and wanted to share my comments as well as my notes & highlights.
Here is the link for Oracle DRM Solution. Continue reading