Transactional Fact Tables

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

These fact tables represent events that occurred at a specific point in time and space. They let us analyze data in extreme detail. Rows in these tables are found only if events take place. For example if there is no observation for a patient a given period then there is no information available for him and we won`t get any data for him in that period. Because of their unpredictable sparseness, we use other types of fact tables as described below.

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Dimensional Roles

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Sometimes a dimension is linked with a fact table multiple times. Each of these is called a dimension role. Although the dimension is stored as one physical table, each of its roles is implemented as a separate view, ideally with unique column names. This enhances the usability of the schema when querying.

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Surrogate Keys

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Surrogate keys are used to join fact tables to dimensions. Surrogate keys isolate the data warehouse from changes to the operational systems, help in integrating data into dimensions coming from different sources and offer good performance when used in joins as they are simple integers. Lastly, they are used in tracking changes in dimension tables.

Click here for example

 

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Best Practices for Gathering Requirements

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Here are a few upcoming events that might be of interest:
 
Top 25 Info Managers — Learn from experienced practitioners about today’s info management challenges.
Monday, Nov. 29 @ 3 ET
http://www.information-management.com/dmradio/-10019166-1.html
 
Data Quality as the Cornerstone for MDM & Data Governance
Veteran Analyst Robin Bloor will brief data quality vendor Informatica.
Tuesday, Nov. 30 @ 4 ET
https://bloorgroup.webex.com/bloorgroup/onstage/g.php?t=a&d=661174755
 
Back to Basics: Best Practices for Gaterhing Requirements
Four experts will discuss how to make sure that projects deliver the desired value.
Thursday, Dec. 2 @ 3 ET
http://www.information-management.com/dmradio/-10017562-1.html

 
Finally, the ‘011 DM Radio speaker submission deadline of Dec. 1 fast approaches. We already have well over 350 submissions for next year’s 176 speaking slots. No one pays or gets paid to speak on DM Radio. Sponsorships are sold separately through the sales staff. Here’s a link to the ed cal (in a zipped folder):
http://www.mobiusmedia.com/DMRadioEdCal2011.zip
 
Follow me on Twitter? http://twitter.com/mobiusmedia
 
Thanks!!
 
Eric Kavanagh
DM Radio Host
512.281.4697 (office)
512.426.7725 (cell)
dmradio@sourcemedia.com
http://info-mgmt.com/dmradio

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

The Cornerstone of Data Governance

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

[amazon-productcloud]3a1bcc99-70a5-48a8-a6ad-f3a9066d8dd3[/amazon-productcloud]

Organizations are increasingly realizing the power of clean data, and the dangers of dirty data. The question remains: How can you secure a strategic view of enterprise data quality? Register for this episode of The Briefing Room to learn from veteran IT analyst Robin Bloor, who will detail an end-to-end data quality strategy, how it can drive successful MDM initiatives, and why Data Governance must focus on people and process, not just tech.
 
Data Quality as the Cornerstone of Data Governance and MDM
The Briefing Room with Robin Bloor and Informatica
https://bloorgroup.webex.com/bloorgroup/onstage/g.php?t=a&d=661174755

 
Each episode of The Briefing Room includes:
a 5-minute topical intro by yours truly & the analyst
a 15-minute technical presentation by an innovative vendor
a 5-minute response by a renowned industry analyst
a 15-minute unscripted briefing with the analyst: back-and-forth
a 15-minute Q&A involving all attendees and Tweeters
a 5-minute wrap-up of key elucidations from the show
You can check out the archives for companies like Denodo Technologies and Talend here:
http://www.thevirtualcircle.com/briefingroom/the-briefing-room/
 
Dec. 1 Deadline for DM Radio Submissions
 
If you’ve already submitted ideas for our 2011 DM Radio Schedule, thanks!! If not, our deadline fast approaches. Please check out the ed cal (in zipped folder linked below; pop-up blocker may stop it the first time you click), and send us any suggestions you may have. We need speaker names and episodes. You’ll see we’re doing 44 shows next year, and are eager to hear as many voices as possible.
 
2011 DM Radio Editorial Calendar
http://www.mobiusmedia.com/DMRadioEdCal2011.zip
 
Thanks so much!

Eric Kavanagh
DM Radio Host
504.281.4697 (office)
512.426.7725 (cell)
http://info-mgmt.com/dmradio
http://twitter.com/mobiusmedia

Courtesy: http://info-mgmt.com/dmradio


What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful