ODI 12 LOOKUP Components

In the depths of time before ODI 12c, ODI Studio had a fairly simple canvas to design our interfaces. We dropped on our datastores (tables) and then dragged columns between tables to create joins, and columns to the canvas to make filters. If we needed to use expressions we just typed them on the target […]

Read More

OBIA 11g: Dimension Ch-Ch-Changes

A little primer on Slowly Changing Dimensions (SCD). Slowly Changing Dimensions are a star schema design principle and design pattern used to reflect how source data field changes are handled in dimension tables. There are basically 5 types that I know of. Of which 2 are the most prevalent and used in OBIA. These 2 […]

Read More

Making Stuff Up

My whole data career has been about finding the truth within data, seeking correlations within and between data sources (and not always relational sources at that). You get to notice patterns in the world and even develop skills to spot outliers on a rapidly scrolling screen. In those early days I used tools like i2 […]

Read More

When Node Manager and OPMN Won’t Play Nicely

Who doesn’t love a solid VM workstation? I’m a big fan of these given their scalability and low maintenance (just update that master image and redeploy!). Not to mention the fact that I can use fancy buzzwords like “cloud” and “virtualization”. Jokes aside, VMs are awesome developer tools and here at Red Pill, we recommend using […]

Read More

The Cage Match between OBIEE Answers and Data Visualization

Last week I presented at the BIWA Summit a “Cage Match” between Oracle Business Intelligence (OBIEE) Answers and Data Visualization. In full disclosure, these slides were created by Kevin McGinley and I simply was the presenter of these slides. However, I believe that I set the bar high for when Kevin presents these next. 🙂 This […]

Read More

Does Oracle Database 12c Just Not Work on Windows?

I’m super-excited about a presentation I’m giving with Kellyn PotVin-Gormanat RMOUG Training Days next month, called Performance Analytics: Visualizing the Power of the AWR Warehouse. Alright… if you insist… I’ll give a quick plug. Kellyn and the team have been working to build the AWR Warehouse component of Enteprise Manager to store Automatic Workload Repository (AWR) history for the […]

Read More
Page 3 of 612345...Last »