Dear unisinc,
Welcome to News@dataWarehouse.com,
our weekly newsletter that covers upcoming events, new content and weekly
forum activity.
This issue sponsored
by:
SYNCSORT IS
THE KEY TO HIGH SPEED DATA PROCESSING!
FREE TRIAL &
FREE RECORDING KEY CHAIN!
Try SyncSort
and drastically cut your data warehouse
load time! Go
to:
http://www.syncsort.com/whc20
............................................................................................
............................................................................................
Issue Contents:
- Site
Events
- Recent
Articles
- Industry
News
- Excerpts
from the Forums
- Upcoming
Events
............................................................................................
............................................................................................
SITE EVENTS
The online trade
show, "Building a Data Warehouse Infrastructure
to Support BI
Initiatives," is available at www.dataWarehouse.com/tradeshow.
Register to
view keynote presentations by Claudia Imhoff, William
McKnight and
Ramon Barquin. Other presenters include Pieter Mimno,
Brenda Moncla,
Ken Kregelman, Kathy Long and Dan Lindstedt.
You won't want
to miss the panel discussion on The Impact of Web
Services which
addresses the definiton of Web services, a description
of the evolution
of this technology and the business application.
Check out the
vendor booths in the exhibit hall: Cognos, Computer
Associates,
DataFlux, IBM, Lakeview Technology, Microsoft, Netezza,
Teradata and
Trillium.
Visit www.dataWarehouse.com/tradeshow/.
...................................................................................
............................................................................................
RECENT ARTICLES
Modeling
Matters: The Semantics of Surrogate Keys and Business Keys, Part 1
by Tom Johnston
Surrogate keys
cannot enforce the semantics of the tables to which they belong; therefore,
these tables must contain a unique identifier such as a business key to
have meaning.
http://www.datawarehouse.com/iknowledge/articles/article.cfm?ContentID=3400
Data Vault:
The Next Evolution in Data Modeling, Part 2
by Dan Linstedt
Part 2 of this
series provides a look at implementing and building a Data Vault along
with a sample Data Vault structure.
http://www.datawarehouse.com/iknowledge/articles/article.cfm?ContentID=3401
Amica Life
Insurance Surpasses Goals with Predictive Modeling from Unica’s Affinium
by Jen Sullivan
Case study:
Amica drives greater revenue, improves lead flow for sales and better allocates
their marketing dollars with Unica’s Affinium.
http://www.datawarehouse.com/iknowledge/articles/article.cfm?ContentID=3402
............................................................................................
............................................................................................
INDUSTRY NEWS
Hitachi Data
Systems and Network Appliance Collaborate on Storage Management
http://www.datawarehouse.com/iknowledge/news/news_body.cfm?ContentID=3398
Red Hat to
Meet Requirements for Modular Communications Platforms
http://www.datawarehouse.com/iknowledge/news/news_body.cfm?ContentID=3399
New Aberdeen
Report Forecasts Market Through 2005, Examines Adoption Trends
http://www.datawarehouse.com/iknowledge/news/news_body.cfm?ContentID=3395
Sage CRM
Roundtable Focuses on End-User Training
http://www.datawarehouse.com/iknowledge/news/news_body.cfm?ContentID=3397
Object Management
Group Adopts Standards and Forms Government Special Interest Group
http://www.datawarehouse.com/iknowledge/news/news_body.cfm?ContentID=3396
Central Command
Releases Its Top 12 Viruses For November 2002
http://www.datawarehouse.com/iknowledge/news/news_body.cfm?ContentID=3394
............................................................................................
............................................................................................
EXCERPTS FROM
THE FORUMS
Interesting
message from our forums
Forum: Calculated
Measure in SQL Server
I faced the
same issue in one of my projects. Our problem
was when we
were viewing some data against the Customer
dimension, which
had some 20,000 records. The issue is
regarding Excel.
Excel does not have that much memory to
calculate and
store a huge amount of data in pivot table.
You can try
by increasing the virtual memory in your machine.
What we did
as a temporary solution was to pull just the
top 50 customers
and then at a later point in time started
using Data Analyzer
which is a proprietary front-end tool
from Microsoft.
Sanjoy
............................................................................................
............................................................................................
UPCOMING EVENTS
The Corporate
Information Factory in a Packaged Solution
Date: December
11, 2002
Time: 9 a.m.
Pacific
Do you have
the infrastructure required to successfully
roll out enterprise
analytics, offline reporting and
multidimensional
analysis? Join Bill Inmon to learn about
the long-term
advantages and ROI of the Corporate Information
Factory. See
how PeopleSoft's Enterprise Warehouse provides
a packaged solution
that gets results faster with less risk
with predefined
ETL maps and business metrics that integrate
with any business
application.
Register today
at http://www.dmreview.com/master.cfm?navid=321
Improving Day-to-Day
Decision Making with Enterprise Business Analytics
Date: January
15, 2003
Time: 2:00 p.m.
Eastern
Decisions, decisions,
decisions. Join DM Review and Unisys
for a free Webinar
on how Business Analytics can help take
the stress out
of your daily business decisions and quickly
help you make
the right call. Guest speakers: Dr. Claudia
Imhoff, president
of Intelligent Solutions, Clay Young, vice
president of
marketing at ProClarity, and Shawn McPherron,
business development
manager at Unisys. Don't miss this
information-packed
event-register today!
http://www.dmreview.com/master.cfm?navid=330
Beyond the Report:
Finding Actionable Information in your Data
Date: Every
Friday through December 2002
Time: 2:00 p.m.
Eastern
Are you struggling
to find information in your sea of data?
Register for
Dimensional Insight's FREE webinar - "Beyond the Report"
and reveal the
actionable information you need to make better
decisions, instantly!
http://www.dimins.com/web_based_bi.html
............................................................................................
............................................................................................
ARTICLE SUBMISSIONS
We are always
looking for article submissions from our community members!
Please contact
me via e-mail at editor@dataWarehouse.com,
for more
information
on publishing your article to dataWarehouse.com.
Sincerely,
Mary Jo Nott
Web Editor
dataWarehouse.com
To unsubscribe
from News@dataWarehouse.com
please email
to:
unsubscribenews@datawarehouse.com
............................................................................................
............................................................................................
Thanks to this
week's sponsor:
Syncsort
http://www.syncsort.com/whc20