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
<alexandre.gorbatchev_at_avermann.de> 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: alexandre.gorbatchev_at_avermann.de
>
> 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: 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 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: 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 Mon Oct 07 2002 - 09:53:37 CDT