Yes it is ok to have sequences as the primary keys.
The dimension should not use keys from the source
systems as their own keys. They must be independant.
Also, since the PK of the dimensions are foreign keys
in the fact tables, if using a non-generated key you
will increase the size of the fact tables for nothing.
I've never put relationsips between dimension tables.
All the validation is done before the load in the
staging area.
- Inder.Singh_at_gecits.ge.com a écrit : >
> Hi,
>
> I am in the process of designing the data warehouse.
> My Question is can I
> define the relationship between dimension tables.
> Like I have
> country,customer and time zone dimension tables. Can
> I add relationship
> between customer,country and time zone just to
> validate the data before load
> whether the country and zip code is correct or
> should I integrate the
> country and time zone with customer itself. If I
> integrate this. Is it going
> to affect the performance. 'cos for every record it
> is going to validate all
> these things before load.
>
> Can I create sequences for primary keys(fact tables
> and for some of the
> dimenasion tables also). Is it OK to have a sequence
> as primary key.
>
> I need your expert views on this.
>
> Regards,
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: Inder.Singh_at_gecits.ge.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Stéphane Paquette
DBA Oracle, consultant entrepôt de données
Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail :
http://fr.mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
INET: stephane_paquette_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jun 12 2002 - 15:39:23 CDT