The Data Challenge Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” datasets–think census, stock market, and employment and inflation rate data–known to be publicly available? […]
As a business professional with little prior technical experience who moved over to the technical side of an Oracle-centric organization, the Oracle Technology Network (OTN) was an invaluable resource for me to quickly make the transition from newbie to full fledged Oracle developer. Thanks to OTN resources like product documentation, technical articles, discussion forums, tutorials, […]
If you read my Oracle Open World: A Newbie’s Retrospective post, I’ve hopefully convinced you that conferences are must-attend events. The knowledge-gain and networking opportunities offered across a few days simply can’t be matched elsewhere. To maximize your conference experiences, you should not only attend, but also speak. How does one get started on the conference speaking circuit? […]
This past week, I had the honor of not only attending, but speaking at Oracle Open World 2016. After a decade of working with Oracle technologies in the data integration, BI & analytics, and big data domains, attending and speaking at this event marked a much-anticipated career milestone on my end. With >60,000 attendees and […]
“This is your last chance. After this, there is no turning back. You take the blue pill — the story ends, you wake up in your bed and believe whatever you want to believe. You take the red pill — you stay in Wonderland, and I show you how deep the rabbit hole goes. Remember: all I’m offering is the truth. Nothing more.” […]
If you work with OBIEE 11g in an administrative role, one of the most debilitating issues you can experience is an Admin Server that fails to start. A large majority of OBIEE configuration and management tasks take place within the WebLogic Server Administrative Console and Enterprise Manager; when the Admin Server is down, neither tool […]
If you’ve ever looked at the ODI Menu Bar or File menu, you’ve seen that there are two separate save options: Save and Save All. Big deal, right? Everyone knows the difference between Save and Save All. (If you don’t, Save will save only one object at a time, the active object you have open/are […]
ODI 12c Studio slow to respond? Receiving low or out of memory warnings? ODI 12c Studio crashing? With an out-of-the-box ODI 12c installation, the memory allocated to ODI Studio is generally too low to handle complex tasks — multiple modifications on a complex mapping, regenerating multiple scenarios, prolonged development sessions, etc. When completing such complex tasks over […]
If you’ve ever developed an OBIEE Repository (RPD) in which you’ve configured a multi-table Logical Table Source (LTS), you’ve likely been plagued by the following warning: There are physical tables mapped in Logical Table Source “Logical Table Source Name” that are not used in any column mappings or expressions. If you’re a Type-A OBIEE Developer […]
In my previous post, I discussed the transition from a Type 1 to a Type 2 Dimension structure after initial implementation. Today we’ll maintain our focus on Type 2 Dimensions and highlight derived effective dating and its timestamping implications. Why Effective Date? Within Type 2 Dimensions, it is essential that each record be effective dated […]