Home » Developer & Programmer » Data Integration » star schema
star schema [message #93216] Sun, 23 November 2003 05:19 Go to next message
ramu
Messages: 82
Registered: February 2001
Member
my question is what is star schema and what is snow flake star schema.
when we go for the star schema and when we go for the snow flake star schema
please send the answer immediately
Re: star schema [message #93219 is a reply to message #93216] Sat, 29 November 2003 03:09 Go to previous messageGo to next message
anil kumar
Messages: 16
Registered: August 2002
Junior Member
Star Schema is a multidimensional model where each of its disjoint dimension is represented in single table.

Snow flake schema is similler to a star schema.
Snow flake schema is normalized multidimension schema where each of disjoint dimention is represented in multiple tables.
Star Schema can become a snow flake schema.
Re: star schema [message #93250 is a reply to message #93216] Sun, 22 February 2004 09:06 Go to previous messageGo to next message
umair khan
Messages: 1
Registered: February 2004
Junior Member
my question is what is star schema and what is snow flake star schema.
when we go for the star schema and when we go for the snow flake star schema
please send the answer immediately
Re: star schema [message #93267 is a reply to message #93216] Tue, 30 March 2004 04:35 Go to previous messageGo to next message
bashir
Messages: 3
Registered: May 2002
Junior Member
I want to know the difference between star schema VS snowflake.
thanks
Re: star schema [message #93276 is a reply to message #93216] Wed, 14 April 2004 13:33 Go to previous messageGo to next message
Anonymous
Messages: 39
Registered: March 2002
Member
Check this out. A snowflake star schema is the same thing, but contains dimension rollups making it look like a snowflake in an ER Diagram.

[Updated on: Mon, 24 April 2006 02:03] by Moderator

Report message to a moderator

Re: star schema [message #93313 is a reply to message #93219] Sun, 04 July 2004 23:54 Go to previous messageGo to next message
VijaySarathi
Messages: 1
Registered: July 2004
Junior Member
Hi,
Is there anything like star flake schema..We know snow flake schema. But got confused about this star flake schema.
Anybody, any idea on the same would be appreciated.

Thanx and regards
Vijay
Re: star schema [message #93371 is a reply to message #93216] Fri, 24 September 2004 19:34 Go to previous messageGo to next message
farook
Messages: 6
Registered: September 2004
Junior Member
my question is what is star schema and what is snow flake star schema.
when we go for the star schema and when we go for the snow flake star schema
please send the answer immediately



Replies:
Re: star schema,snow flak schema. [message #93440 is a reply to message #93216] Fri, 14 January 2005 08:37 Go to previous messageGo to next message
lenin
Messages: 1
Registered: January 2005
Junior Member
i WANT ALL ANSWERS
Re: star schema,snow flak schema. [message #168746 is a reply to message #93440] Sat, 22 April 2006 00:01 Go to previous message
dave33john
Messages: 3
Registered: April 2006
Junior Member
You can get all answers for star and snowflake schema...
download & read this book

http://www.redbooks.ibm.com/abstracts/sg247138.html?Open
Previous Topic: How to get a list of input/output objects to a mapping
Next Topic: Analytic Space Manager error
Goto Forum:
  


Current Time: Fri Mar 29 03:30:38 CDT 2024