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. --- [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 [EMAIL PROTECTED] ___________________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
