LewisC’s An Expert’s Guide To Oracle Technology
In keeping with my goal to help some of my peers out there find a job, today I have a very experienced architect looking on the East Coast. He would prefer the New York area but recognizes that, becaus…

IBM offers a SaaS Specialty partner program that provides resources, technical enablement and marketing support to its partners. IBM also offers hardware, software and infrastructure technologies to help its Business Partners deliver secure and scaleable cloud services. In addition, Business Partners gain access to over 40 worldwide IBM Innovation Centers, providing them with technical support [...]

Click to continue reading “Financial Services in the Cloud”… Read the rest!

LewisC’s An Expert’s Guide to Oracle Technology
Well, I have been using Oracle’s new SQL Developer Data Modeler (OSDM) for a couple of months now. I’ve upgraded to beta 2. I have to say I really like it. I have given some feed back and the response …

Posted in November 29, 2008 ¬ 2:03 pmh.Comments for An Expert's Guide to Oracle TechnologyComments Off

When you say gaps, do you mean instances where you might have late arriving dimensional data or dirty data that needs to be cleaned prior to loading? In those cases, I usually use “data not arrived yet” and “dirty record” FKs. I set up a surrogate key like -1, -2 whatever. When the data finally comes in and is cleaned, I update the fact to the correct key value.

Posted in November 29, 2008 ¬ 12:23 pmh.Comments for An Expert's Guide to Oracle TechnologyComments Off

I’m curious how you deal with gaps in referential integrity: our ETL team coined the phrase “shoring up the dimensions” when referring to the dummy records I require to be built. (BTW, since the dummy records are ETL-created, I didn’t have any issues with ETL-enforced integrity — until I found not everyone was “rabid about referential integrity”).

Posted in November 28, 2008 ¬ 5:18 pmh.Comments for An Expert's Guide to Oracle TechnologyComments Off

Duke,

That is pretty much where I am.

In this instance, the ETL is being handed off to others who will write the code (hand written, they decided not to use an ETL tool). There is no real documentation as of yet and there is a short time line for delivery.

Posted in November 26, 2008 ¬ 4:55 pmh.Comments for An Expert's Guide to Oracle TechnologyComments Off

sschurig,

Interesting viewpoint. Thanks for sharing it. That’s the kind of info I was looking for.

I agree with at least putting them in and not enforcing. That would be at a minimum, for me.

I do disagree with some of your points, though. I believe the db should be the final say of RI. I actually use RI when doing ETL to make the ETL less complicated. Why put it in code when it … Read the rest!

LewisC’s An Expert’s Guide to Oracle Technology
I am soliciting opinions here. First, though, some back story.
Way back when, when I was first moving on the track to data modeler and architect, I was responsible for designing schemas and application…

Click to continue reading “Foreign Keys in a Data Mart”… Read the rest!

LewisC’s An Expert’s Guide To Oracle Technology
Once more unto the breach, dear freinds, once more.
Express Scripts Warns of Potential Large Data Breach Tied to Threat
I used Express Scripts on at least one prior job so this kind of sucks for me as …