April 1, 2008 at 3:27 am
What is meant by Fact,Dimension,Lookup?Can any one please explain me regarding that?
April 1, 2008 at 8:25 am
Fact and Dimension are terms from Data Warehousing where Dimensional Modeling of data is used instead of Relational Modeling. It's still understandable to SQL DBA's and even do-able in vanilla SQL, the basic difference is that the "Normalization Rules" are different. Here's a link: http://en.wikipedia.org/wiki/Dimensional_database
"Lookup" probably just means using a dimension id in a fact record to lookup the corresponding data in the dimension table (Fact tables have no data in them, just pointers to the Dimension tables where the data is stored).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
April 1, 2008 at 8:56 am
Might start somewhere like this: http://www.cs.bris.ac.uk/maintain/OracleDocs/server.816/a76994/logical.htm
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply