Data modeling in a datawarehouse is there to ease and make querying faster.
I have always discplined myself to use star schema and never snowflake. The "Which one is easier to implement and easier ETL ?" is not a good question as your data model should not be design for the ETL procecess but only for the querying. Oracle star transformation join technique is designed to handle star schema. HTH --- Alexandre Gorbatchev <[EMAIL PROTECTED]> a écrit : > Dear Data Warehouse Experts, > > Could you please share you experience with snowflake > and star data models. > How do you choose between them? > What problems may arise? > Is star schema preferred for Oracle? > What is users' experience with those schemas? Which > one they like more and > why? > Which one is easier to implement and easier ETL? > Are there other patterns for DW? > > I would like to check/confirm/change my possibly > subjective point of view to > more objective perspective. I would appreciate your > thoughts or links where > I can review practical conclusions. > > TIA, > Alexandre > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Alexandre Gorbatchev > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > 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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
