The 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 created to map between the Informatica/DAC concepts to their ODI counter part(s). After the two cross-reference tables, there are 3 images used as a location reference for these ODI components.
A look at OBIA shift to use SCD1_WID in place of ROW_WID for Slowly Changing Dimensions
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 types are named Type 1 and Type2. (The other 3 are Time-stamp, Type 3 and Hybrid).
So, some of you may have noticed that I took “real” job this week. I am now the Senior Technical Evangelist for a cool startup company called Snowflake Computing. Basically we provide a data warehouse database as a service in the cloud. Pretty cool stuff. (If you want to know more, check out our site […]
Have you heard? Dan Linstedt has just had his new book published on Data Vault 2.0. It is called Building a Scalable Data Warehouse with Data Vault 2.0. If you are at all into data warehousing and agile design, you need to get this book now. So click here and be done. For those of […]
Originally posted on HeliFromFinland:The best news on Friday Oct 23rd was that version 4.1.2 of Data Modeler came out! We were really waiting for this release because of some bugs on 4.1.1 that made our lives quite difficult. Thank you development team for fixing everything so quickly and releasing 4.1.2 so fast! If you…
So in honor of the upcoming #OOW15 and User Group Sunday Symposiums, I decided to put my video workshop for #SQLDevModeler on Sale! Why use #SQLDevModeler? If you were an Oracle Designer user and are looking for a replacement data modeling tool, or you are using one of the other mainstream, expensive modeling tools and […]
Yes boy and girls, it is that time of year again. Time for the BIG show in San Francisco – OOW15 I will as usual, attend, but only for a few days this year (been away from home too much). My Talk I will be presenting my session Worst Practices in Data Warehouse Design (UGF9985) […]
Originally posted on TH TECHNOLOGY:I am honored to be a finalist in the Oracle Database Developer Choice Awards, in the Oracle Application Express category. I am most impressed with my fellow finalists – amazing devotion to helping the APEX community – and humbled to be included in such a crowd. Congratulations to all! Please…
So this started with a not so innocent tweet from Jeff Smith: @GuillaumeSL i’m betting @KentGraziano could answer your question right away — Jeff Smith (@thatjeffsmith) September 14, 2015 //platform.twitter.com/widgets.js Well, I sort of answered at least part of the question (eventually), but along the way the topic of using super types and sub types […]