Read this message online.
.
. .
Sandhill Logo Erwin Times Logo July 2010 Newsletter
.
Image
.
.
. .

Summer is upon us and many of you already will have enjoyed a well-earned break.  Hopefully, this issue will give you some ideas to expand your use of ERwin tools in the busy autumn ahead and make entries in your diaries for the upcoming events, particularly the UK ERwin User Group on November 17.

Talking of events, you may notice that there are no training events scheduled.  We are currently planning some, so if you have a particular interest in attending a course, please let us know where you are and what your particular area of interest is, and we will endeavour to cater for your requirements.


Regards

Simon Carter

Sandhill Consultants		 . .
.
.
.
. . In this issue:
> CA World 2010
> Into Africa
> Data Warehouse Corner
> Tips & Techniques

EVENTS

Thursday, September 16, 2010
Business Intelligence Day, Belgium, key-note speaker Bill Inmon.  Come and see us at the CA booth.

Wednesday, November 17, 2010
UK ERwin User Conference, Ditton Manor, Key-note speaker Danny Sandwell, CA, plus technical and user presentations.

 . .
. . . . .
. . . .
.
.
.
.
.
. .
CA World 2010
Since our last issue, we have been busy showing our faces around the world at various events, including CA World 2010 in Las Vegas.
 
Our very own Terry Troddyn delivered a presentation on editing Forward Engineering Templates and Joe Cullen, author of our Data Warehouse Corner conducted a Dimensional Modeling workshop.  Both have articles in this issue.

Also of interest was Danny Sandwell's "State of the Union address" on the current state and future direction of ERwin.  If you haven't seen it you can replay the recorded webcast version.
.
.
.
.
. .
INTO AFRICA
We are very pleased to announce the expansion of our team and global reach with the appointment of Jeff Harris as our local representative in South Africa. 

Jeff has a strong track record in data architecture and his reputation extends far beyond his homeland.  We look forward to working with Jeff and bringing the Sandhill experience to South Africa.
.
.
.
DATA WAREHOUSE CORNER
.
.
.
In this issue, Joe talks about two important concepts in data warehousing:

> Normalization
 
> Slowly Changing Dimensions
.
.
.
TIPS & TECHNIQUES
.
.
.
Customising the Forward Engineering Template (FET):

Forward Engineering Templates are dbms specific templates which control the generation of DDL.  Introduced to ERwin in V7.0, their usability greatly improved in V7.3 with the arrival of the new TLX macro language and its Integrated Development Environment (IDE).
.
> read more 
.
Removing underscores from reverse-engineered logical names:

When you reverse-engineer a logical/physical model from a database, you usually end up with unwanted underscores in the entity and attribute names.  This article helps rectify this situation.
.
> read more 
.
.
.
About us
Sandhill Consultants Ltd is a worldwide organisation providing industry-acclaimed solutions, services and training to businesses, organisations and individual professionals since 1989.
> Our UK-based world headquarters serves organisations located in Europe, the Middle East, and Africa
> Our Canada-based North American headquarters serves organisations located in the Americas
.
.
.
.
.
Sandhill Consultants Ltd, St John's Court, Brewery Hill, Grantham NG31 6DW
t:+44 1476 568708 | f:+44 1476 568620 | e: info@sandhillconsultants.com
Registered No. 2411190, Cardiff

Want to unsubscribe?
.
. .
.