ODS and data modeling

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Wed, 02 Jul 2003 13:04:23 -0700
Message-ID: <F001.005C16C6.20030702125536@fatcity.com>

Hi
all,
<SPAN

class=236034819-02072003>
I'm doing the data
model for an Operational Data Store. The ODS will serve to consolidate data from many operational systems and mainly from a new ERP, then most of the data will go in an existing data warehouse.
<SPAN

class=236034819-02072003>
I've worked with
datawarehouses before but never with ODS.
<SPAN

class=236034819-02072003>
I've check about
Bill Inmon and at IBM red book site on the web. Any other good site
on ODS ?
<SPAN

class=236034819-02072003>
Also, what are your
arguments when choosing between 1 table handling all codes or having a table for each code.
<SPAN

class=236034819-02072003>
<SPAN

class=236034819-02072003>
<SPAN

class=236034819-02072003>TIA

Stephane Paquette<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Administrateur de bases de donnees
Database Administrator
<SPAN

style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
<SPAN lang=FR-CA
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-ansi-language: FR-CA; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><A href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] Received on Wed Jul 02 2003 - 15:04:23 CDT