Posts Tagged ‘Oracle’

As I have been writing my blog posts about ODI, my director recently reached out to me asking why I don’t put a blog posting on how to load a slowly changing dimension table.  I thought that was a great idea as when I first started to use the tool this was a major requirement […]

This will probably be one of my shortest posts on ODI, but I figured if I am covering  pretty much all the basics of ODI, it would be good to show you how to use ODI’s scheduler and also show you how to schedule your ODI load plans. As title of the post states “Oracle […]

Hopefully everyone has been enjoying my many post on Oracle Data Integrator (ODI), again its starting to become one of my favorite ETL or E-LT software solutions.  With that being said, I wanted to continue my discussions with ODI and create a post showing you all how to create a ODI scenario and load plan. […]

So I’m hoping you all read my previous post on “Creating an Oracle Data Integrator (ODI) Interface” and hopefully it was simple to follow.  Today, I want to show you how to take your interface and bundle it into a ODI package with other ODI components in which will all you to run more than […]

Hopefully you all had a chance to check out my recent blog posting “Getting to know Oracle’s Oracle Data Integrator (ODI).”  If you haven’t checked it out yet, I urge you to check it out.  Well to continue on the topic of Oracle Data Integrator (ODI), I wanted to put together a few posts on […]

As an avid user of IBM DataStage for over 8 years I was recently on a client engagement where I had to use Oracle’s Oracle Data Integrator (ODI).  At first I was disappointed as I was out of my confront zone.  But after a week or two I was very surprised how quickly I was […]

Life sciences companies are devoted to developing sophisticated drugs, services and other therapies, yet many still rely on spreadsheets, paper, and overly-complicated homegrown systems to manage activities related to clinical trials. It’s hard to believe, considering the myriad benefits that a tried-and-true clinical trial management system (CTMS) can provide. It’s widely understood that a CTMS […]

With a variety of clinical trial management systems (CTMS) on the market, determining which one is right for your organization can be difficult. Ovum, a leading technology research and advisory firm, recently released Decision Matrix: Selecting a CTMS Solution, 2013–14, a report that covers the clinical IT landscape, outlines critical factors that life sciences companies […]

On a recent project, I was faced with a requirement to scan the contents of a folder and load all the files into their respective staging tables. There were multiple file types – Customer file, Store file, Products file, Sales file, etc. Every day, we received zero to many files for each type of file. […]

Patrick Abram, Director at Perficient, presented at KScope14 this week about using Oracle products for restaurant operations analytics: Multi-unit, multi-concept restaurant companies face challenging reporting requirements. How should they compare promotion, holiday, and labor performance data across concepts? How should they maximize fraud detection capabilities? How should they arm restaurant operators with the data they need […]

At Oraclae’s KScope User Group meeting yesterday, I heard a really riveting presentation given by Jake Porway, Founder of DataKind, which made me take pause. It really brought to light Big Data’s capacity to impact all aspects of business *and* human life itself.  The point made was that we are at an inflection point in […]

A huge number of my projects are platform upgrades, and every time I ask my customers why they haven’t applied a single published fix for any of the products involved since the system was built (sometimes upwards of 7 years ago). They usually reply with a variation on the old trope, “If it ain’t broke, […]