view counter

Data Warehousing Feed

Oracle Data Warehousing, reporting, online analytics, and data mining resources, news, and support articles.

Better Data Modeling: My Top 3 Reasons why you should put Foreign Keys in your Data Warehouse

This question came up at the recent World Wide Data Vault Consortium. Seems there are still many folks who build a data warehouse (or data mart) that do not include FKs in the database. The usual reason is that it “slows down” load performance. No surprise there. Been hearing that for years. And I say […]

Live from the 1st Annual World Wide Data Vault Consortium: Day 3

Well it was the last day of the 1st annual WWDVC. What an event is has been. (See recap of Day 1 and Day 2, here and here) Don’t forget you can see all the action by searching on #WWDVC on twitter. Agility and Data Vault Long time data vault advocate Tom Breur opened our […]

Live from the 1st Annual World Wide Data Vault Consortium: Day 2

Wow has is been an amazing event with many amazing people from around the globe. I am VERY glad that I took the time and came to St Albans for this inaugural event. As with Day 1, there is just too much great information for me to adequately cover it in a blog post (or […]

Live from the 1st Annual World Wide Data Vault Consortium: Day 1

It has been an amazing and historical day in chilly St Albans, Vermont on this first day of Spring. In a little hotel on the edge of a little town is a gathering of some of the brightest minds in the world of data vault. They have come from around the USA, Canada, Germany, Australia, […]

Quote of the day: You can only make others better by being good yourself

You can only make others better by being good yourself. – Hugh R HanelsFiled under: Quotes Tagged: quote

2nd webinar of @LAOUC

Originally posted on Gurcan Orhan's Oracle Data Integrator Blog:Save the date for second webinar of LAOUC. I will be talking about How to handle DEV&TEST&PROD for ODI (click for registration) for LAOUC (Latin America Oracle User Community) on this Thursday (6th March  5PM (BRT) – 8PM GMT – 10pm (GMT +2)). We will be starting a…

There’s no thrill in easy sailing..

There’s no thrill in easy sailing                 when skies are clear and blue, there’s no joy in merely doing things                which any one can do. But there is some satisfaction                  that is might sweet to take, when you reach a destination                 that you thought you’d never make. - Unknown Filed under: Quotes, […]

It is the responsibility of leadership to work intelligently

“It is the responsibility of leadership to work intelligently with what is given, and not waste time fantasizing about a world of flawless people and perfect choices.” – Marcus Aurelius Hmmm….so how do your leaders roll? Do you need to find new leaders? Are you that leader? Cheers, Kent The Oracle Data WarriorFiled under: Quotes […]

Better Data Modeling: The Oracle Data Warrior Speaks!

Looks like I will be doing a bit of speaking this year at a number of  events around the country, and later on, the globe (more on that later). As usually all my talks will center around using SQL Developer Data Modeler, data modeling standards, Data Vault, agile, or a combination of all of the […]

Better Data Modeling: Color Code Your Data Model Diagrams using #SQLDevModeler

One of the standards I recommend in my book  Check List for Doing Data Model Design Reviews is to use color in your diagrams to visually differentiate types of entities or tables. As luck would have it, Oracle SQL Developer Data Modeler has a feature that makes this very easy. It is Classification Types. In […]

view counter