At work last week I lifted the covers on the Red Pill Analytics Slowly Changing Dimension ODI IKM for Oracle. If you haven’t heard about this knowledge module, it was specifically written to take a dimension source table and transform it to a slowly changing dimension target table. Unlike other similar IKMs, this module uses […]
Mind the Gap — Getting the Number on ODI Sequences Read More »
ODI, TipsIn 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
ODI 12 LOOKUP Components Read More »
ODI, TipsThe Big difference between Oracle BI Applications 7.9.X and 11g is the Integration or ETL tier. 11g no longer uses DAC or Informatica. Instead Oracle Data Integrator replaces those components. This cross-reference I created here is for those thinking of or moving to 11g from 7.9.X. Below, you will find a cross reference guide I
OBIA: 7.9.X to 11g (Informatica/DAC to ODI) Cross Reference Guide Read More »
OBIA, TipsA 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
OBIA 11g: Dimension Ch-Ch-Changes Read More »
OBIA, TipsTo celebrate Women’s History Month, the morning radio program today was asking people to name a woman that has influenced them whom they’ve never met. This question got me thinking. What would you say? Who’s influenced you? The responses on the program ranged from Lady Gaga to Hillary Clinton to Mother Teresa. My response would
Influential Women in Technology Read More »
GeneralMy 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
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
When Node Manager and OPMN Won’t Play Nicely Read More »
OBIEE, TipsWhat are you in for when migrating from OBIEE 11g to 12c? Short answer is there is a lot less pain going from 11g to 12c than there was going from OBIEE 10g to 11g. The upgrade to 12c is an out of place upgrade as was the 10g to 11g which means new software
How It’ll Go Down – Upgrading OBIEE 11g to 12c Read More »
Oracle 12c, TipsOpen the dashboard editor in 12c, you’ll see a few changes. What Changed?? Well, dashboard development has never been the sexiest task, but it is a little simpler now. You can browse to BI content in the Shared Folders, just as you could before, but now you can also browse to dashboard content. In the
It’s the smaller things in life…. Read More »
OBIEE, Oracle 12cHow many times this week have you googled a technical question and found a blog, an article, a forum post or slides from a presentation? I do this multiple times per day! And while my undergraduate degree taught me a lot, especially how to approach problems, I learned most of what I know about business
User Groups Matter Read More »
Events, General, Red Pill News